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.