topic Re: Show most recent plotted value in QlikView

Show most recent plotted value

wendytham — Wed, 25 Nov 2020 16:16:04 GMT

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.

Sergey_Shuklin — Fri, 19 Oct 2018 06:28:54 GMT

Hello, Wendy!

Check the single quote here:

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

ramasaisaksoft — Fri, 19 Oct 2018 07:10:07 GMT

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 — Fri, 19 Oct 2018 07:43:56 GMT

Hi,

Sorry, it's typo.

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

Frank_Hartmann — Fri, 19 Oct 2018 08:08:44 GMT

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

sunilkumarqv — Fri, 19 Oct 2018 08:15:44 GMT

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), '')