Cumulative expression request for combo chart

[vinayvishwanath]

Hi All,

could someone please help in providing cumulative expression for line graph (Combo chart) wherein it is should look as below

This is the one which i am trying to replicate in QS

and below is the original one...

as per the requirement i have to create below views

Actuals cumulative = Only for the past months

Forecast cumulative = Actuals as of past months + future forecast (e.g. Actuals P1-P3 + Forecast P4-P12)

Show 1 decimal point

Dimension used is Month (P1,P2,P3.....P12)

Measures used are Actual, Budget and Forecast values

Thanks

Vinay

[sunny_talwar]

Would you be able to share some sample data with the expected output? or you can map be able The As-Of Table

[vinayvishwanath]

Hi Sunny,

Please find the attached sample data...... i want to replicate the below chart in QS with below requirements. i am able to create bar graphs but for line graph, we have to create depending on below criteria

Actuals cumulative = Only for the past months

Forecast cumulative = Actuals as of past months + future forecast (e.g. Actuals P1-P3 + Forecast P4-P12)

Show 1 decimal point

Dimension used is Month (P1,P2,P3.....P12)

Measures used are Actual, Budget and Forecast values

Please revert for further clarifications

Thanks

Vinay

[sunny_talwar]

Just a quick question... are you doing CrossTable when you are loading this data into Qlik Sense?

[vinayvishwanath]

Yes you are right, i am using cross table.....while loading the data.

[vinayvishwanath]

can anyone help on this on priority?