topic Hi, Please Answer !!! in QlikView

Hi, Please Answer !!!

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

I have 2 tables, 1 for Sales, 2 table for Purchase. On top i have created 2 buttons-- Show Sales, Show Purchase.

When i click on Show Sales Button Prechase table will Disappear , and

When i click on Show Purchase Button Sales table will Disappear. How can i achieve this ????

prat1507 — Thu, 09 Nov 2017 13:15:39 GMT

You can use conditional statement in layout for the tables.

Regards
Pratyush

stabben23 — Thu, 09 Nov 2017 13:21:28 GMT

Hi,

something like this

Peter_Cammaert — Thu, 09 Nov 2017 13:21:50 GMT

Create a new variable. Let's call it vShowSalesOrPurchase
Create a Sales button and add an action that sets vShowSalesOrPurchase to 1
Create a Purchase button and add an action that sets vShowSalesOrPurchase to 2
Create a Sales table/chart and in Layout set the conditional show expression to vShowSalesOrPurchase = 1
Create a Purchase table/chart and in Layout set the conditional show expression to vShowSalesOrPurchase = 2

Best,

Peter

ramcena306 — Thu, 09 Nov 2017 13:35:44 GMT

Hi @Peter, Thank You. It Helps !!