Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to make my chart using load script Flag on CY sales not YTD sales.

Hi All

I have this Expression from chart A :-

money(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/1000)

, $(vMoneyFormatK))

I get 2014 and 2013 sales trend. My issue is for 2014 sales i only want to plot YTD sales which is from Jan till Feb. and not Jan till March.

In order to make my current year sales only display YTD sales , i modify above to below expression :-

money(

Sum (

{<Year={'>$(=year(today())-2)'}>}

if(YTD,sales)/1000)

, $(vMoneyFormatK))

Now my Chart B , only display 2014 sales , and not display 2013 sales line. may i know how to make 2013 sales line display ?

Paul

1 Reply
Not applicable
Author

my qv doc