help! How to create dashboard to show total number of customer by months

[Jaycole]

Dear All,

I am new to Qilk Sense 😉

Would to consult on how to create a nice and interactive dashboard using Qilk Desktop version. Please find attached excel file for your reference.

In the excel, please refer the table listing under tab "Data"; and refer to the expected dashboard outcome in Qilk Sense under tab "Expected Outcome in Qilk Sense ".

Requirement: To show the total number of customer by months.

Many thanks and appreciate!

Cole

[Jaycole]

Hi,

i got error for expression below:

Sum(cnt)/sum({<cif_status>}cnt <Area_Office> cnt)

Error in expression: ')' expected.

Appreciate your help.

[Jaycole]

hi, can i have the .qvf file for above example you've done? i am still struggling on it.... 😞

[OmarBenSalem]

Sum(cnt)/sum({<cif_status>}cnt total  <Area_Office> cnt)

[OmarBenSalem]

I wish I could ! 

It would have been so much easier for me to share the QVF instead of sharing each and every chart / expression.

Unfortunately for both of us, each time I try to attach the QVF, I get an error...

[Jaycole]

Thanks so much! 😃

Maybe you can try to email to me? prettycolecole@hotmail.com

would like to understand the following part, i still struggling on how to create new field as column for Sum, Composition, and so on. 😞

* Chart 5 : Details

Pivot table:

Lines: Area, Segment

Column : Month

Measure (put before column):

- sum : Sum(Total)

- MoM (%) : 

aggr(

(Sum(Total)- above(Sum(Total)))
/
above(Sum(Total))

,Segment, Month)

Ytd : 

aggr(
(Sum(Total)- rangesum(above(Sum(Total),1,RowNo()) ))
/
rangesum(above(Sum(Total),1,RowNo()) )
,Segment, Month)

Composition : Sum(Total)/
sum({<Segment>}total <Area> Total)

[OmarBenSalem]

Done !

[Jaycole]

Got it! much appreciate your help! 😄 will take a look now! thanks a lot!!!

[Jaycole]

Hi, may i know how to create the "Measure" under column in pivot?

[OmarBenSalem]

It's not created under Column; it's under measures.

But if u have more than one measure, this "Measures" value will appear under column.

[Jaycole]

Yeah, just saw it appeared! thanks so much!