Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
erickd1190
Contributor III
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
ayandey18
Partner - Contributor II
Partner - Contributor II

Add the measure in the Highlighted areaCapture.JPG

View solution in original post

5 Replies
ayandey18
Partner - Contributor II
Partner - Contributor II

Add the measure in the Highlighted areaCapture.JPG

shraddha_g
Partner - Master III
Partner - Master III

Field name is missing in 2nd Expression.

ChennaiahNallani
Creator III
Creator III

try

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

erickd1190
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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!