Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

When user select year = 2013 , how to write my expression can display 2017 YTD sales ?

Hi All

I have 3 Table , may i know how to combine into 1 table ?

sheet 2013 = year 2013 compare to CY

sheet 2014 = year 2014 compare to CY

sheet 2015 = year 2015 compare to CY

Meaning instead of having 3 sheet , i only wan to have 1 sheet.

So when user

select year = 2013 , it will display 2013 compare with current year.

select year = 2014 , it will display 2014 compare with current year.

select year = 2015 , it will display 2015 compare with current year.

Hope some one can advise me.

As i don't know how to make the second display 2017 YTD sales when user select year =2013.

Paul

1 Reply
paulyeo11
Not applicable

Re: When user select year = 2013 , how to write my expression can display 2017 YTD sales ?

My QVW