Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
wendytham
Contributor II
Contributor II

Show most recent plotted value

Hi,

For red line, i am able to show the last plotted value,

but for blue line, the same expression used but the value didn't show up.

Red Line: if(Month = 'Oct', sum ({<FY ={'FY2018'} >}Job)/Sum ({<FY ={'FY2018'} >}Sales), '')

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017} >}Sales), '')

I have exported the data in excel to check, the point for blue line is calculated correctly, but nothing is shown.

Please assist.

Thank you.

Untitled.png

5 Replies
Sergey_Shuklin
Specialist
Specialist

Hello, Wendy!

Check the single quote here:

Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')

ramasaisaksoft

Hi Tham,

you missed single quote symbol ' in the expression after the 2017',


so it need to be like below


Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')

wendytham
Contributor II
Contributor II
Author

Hi,

Sorry, it's typo.

In QV, the expression is correct. There is double quote symbol.

Frank_Hartmann
Master II
Master II

I guess its because you are not showing Mar-2017 but Mar-2019 in the chart.

sunilkumarqv
Specialist II
Specialist II

Have you tried selecting the Year FY = 2017 and see if plot value shows up otherwise try to change the calender dynamically


Blue Line: if (Month = 'Mar', sum ({<FY ={'FY2017'} >}Job)/Sum ({<FY ={'FY2017'} >}Sales), '')