Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erickd1190
New Contributor III

Sales Variance: YTD vs LYTD

Hi all!

I need to create a % variance using a KPI chart.

To do this I have wrote the following chart expression but am coming up with a -- in the KPI chart.

Can anyone point out what I am doing wrong?

(SUM({$<fYear={'2016/2017'}>}sale)-SUM({$<fYear={'2015/2016'}>}))/SUM({$<fYear={'2015/2016'}>}rate)

1 Solution

Accepted Solutions
Partner
Partner

Re: Sales Variance: YTD vs LYTD

Add the measure in the Highlighted areaCapture.JPG

5 Replies
Partner
Partner

Re: Sales Variance: YTD vs LYTD

Add the measure in the Highlighted areaCapture.JPG

Partner
Partner

Re: Sales Variance: YTD vs LYTD

Field name is missing in 2nd Expression.

Highlighted
ChennaiahNallani
Contributor III

Re: Sales Variance: YTD vs LYTD

try

(SUM({$<fYear={'2016/2017'}>}sale)-SUM({$<fYear={'2015/2016'}>}rate))/SUM({$<fYear={'2015/2016'}>}rate)

erickd1190
New Contributor III

Re: Sales Variance: YTD vs LYTD

Thank you all! I noticed it first thing this morning. Sometimes stepping away and coming back helps you notice things you were missing before.

However I am afraid that this has not fixed the issue. Even after the change it is still not calculating, just getting the --.

Any other thoughts?

I appreciate it!

Erick

erickd1190
New Contributor III

Re: Sales Variance: YTD vs LYTD

I fixed it!

Turns out I need to adjust my data model to include numeric and text version and use the Text for the expression!

Thank You everyone!