Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

my qv doc

Community Browser