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
Valued Contributor II

How to make my 2 Table ( long expression ) combine into 1 ?

Hi All


I have 2 table , one table is display sales up , and another table is for display sales down.


Because i want to make my table easy maintenance. I want to make this table into 1 table. and

using button to trigger to display the sales up or sales down.


Can some one share with how to do it ?


in my recent post , i have same questions. Some one share with me using button. and create variable , it work fine. But this time my table expression is very long.


Enclosed my QVW which have 2 Tab , will show you the 2 Table .



Paul

2 Replies
paulyeo11
Valued Contributor II

Re: How to make my 2 Table ( long expression ) combine into 1 ?

My QV Doc

uacg0009
Valued Contributor

Re: How to make my 2 Table ( long expression ) combine into 1 ?

Hi Yeo,

I think it's not too hard to make it, you just need to add a variable into the condition, then I think that's ok.

For example, you have a variable vShow_Sales_Up, and you have a button to change it between 1 and 0.

And when the vShow = 1, in the table, you just make condition of the dimension and expressions about sales up to show, and also for sales down.

Hope it's helpful.

Thanks

Aiolos