Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator
Creator

Hi, Please Answer !!!

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 ????

1 Solution

Accepted Solutions
Peter_Cammaert
Partner
Partner

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


Best,


Peter

View solution in original post

4 Replies
prat1507
Specialist
Specialist

You can use conditional statement in layout for the tables.


Regards
Pratyush

stabben23
Master
Master

Hi,

something like this

Peter_Cammaert
Partner
Partner

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


Best,


Peter

View solution in original post

ramcena306
Creator
Creator
Author

Hi @Peter, Thank You. It Helps !!