Qlik Sense Ders 42: Sparklines

Yukarıdaki sembollere ve daha fazlasına ulaşmak için buraya tıklayabilirsiniz.
Örnek için Tableau sample superstore datası kullanılmıştır.
Qlik Sense’te gösterge ve sembollerle grafik yapmak mümkün ancak biraz meşakkatlidir.
Tabloya boyut olarak yıl, hesaplama olarak satış, kar ve aşağıdaki ifadeleri ekleyerek grafiği oluşturabiliriz.
Profit (Circle)
if(sum(Profit)>=0, Repeat('○',5)&'|'& Repeat('●',round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)) & ' '& Repeat('○',5-round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)), Repeat('○',5+round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)) & Repeat('●',-round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)) &'|' & Repeat('○',5))
Profit (Bar)
if(sum(Profit)>=0, Repeat(chr(8193),5)&'|'& Repeat('▇',round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)) , Repeat(chr(8193),5+round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5))& Repeat('▇',-round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*5)) &'|')
Profit (Lolipop)
if(sum(Profit)>=0, Repeat(chr(8193),11)&'|'& Repeat('━',round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*10)) & '●' , Repeat(chr(8193),10+round(sum(Profit)/max(total aggr(fabs(sum(Profit)),[Order Date.autoCalendar.Year]))*10)) & '●' & Repeat('━',-round(sum(Profit)/max(total aggr(fabs(sum(Profit)), [Order Date.autoCalendar.Year]))*10)) &'|') // '░'
Sales/Month
concat(aggr(
pick(ceil(sum(Sales)/max(total aggr(sum(Sales),[Order Date.autoCalendar.Month], [Order Date.autoCalendar.Year]))*6),'▂','▃','▅','▆','▇'),
[Order Date.autoCalendar.Year],[Order Date.autoCalendar.Month]),'',[Order Date.autoCalendar.Month])
Profit (+/-)/Month
concat(aggr(
pick(if(sum(Profit)<0,1,2),'▄','▀')
, [Order Date.autoCalendar.Year] , [Order Date.autoCalendar.Month] ),'',[Order Date.autoCalendar.Month])
Round Sales (K)
Repeat('▇' ,round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Month]))*10)) & ' ' & round(Sum(Sales)/1000)

Yukarıdaki sum(Profit) ifadesinin yanına yukarı/aşağı ok eklemek için ▲ #,##0; ▼- #,##0 biçim desenini kullanabilirsiniz.

The Percent of Sales
sum(Sales)/sum(total Sales)
Pie of Sales
Pick(ceil(sum(Sales)/sum(total Sales)*5),'⭘','◔','◑','◕','⬤','⬤')
Acc
Rangesum( above( sum(Sales)/sum(total Sales),0,rowno()))
Pie
Pick(Ceil(rangesum( above( sum(Sales)/sum(total Sales),0,rowno()))*5),'⭘','◔','◑','◕','⬤','⬤')
Round Sales (K)
Repeat('𝗹',round(sum(Sales)/max(total aggr(sum(Sales),[Order Date.autoCalendar.Year]))*25)) & ' ' &
round(sum(Sales)/1000)
Dots
Repeat('●',round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*10))& Repeat('○',10-round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*10))
Blocks
Repeat('▮',round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*10))
Pipes
Repeat('𝗹',round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*25))& Repeat('⋅',25-round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*25))
Shades
Repeat('█',round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*10))& Repeat( '░',10-round(sum(Sales)/max(total aggr(sum(Sales), [Order Date.autoCalendar.Year]))*10))
Not: Top 10 Viz tricks‘ten ilham alınarak hazırlanmıştır.