Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
Contributor III

Filter Selection

Hi is there anyway i can have the Gross, Return, Total Disc, Net as selection. so user can click on the selection to display the data instead of all show at one table. 
Example ,if user only wan to see Net, click Net, then the table only will show Net figure. 
Capture.JPG

25 Replies
prabunakil
Contributor III
Contributor III
Author

Hi when i click net sales using ur QVW, the gross sales wont hide. is there any missing?

renuka_sasikumar
Creator III
Creator III

Are u talking about the Textobject which shows as GrossSales or the Measure in Chart?

renuka_sasikumar
Creator III
Creator III

Snap.JPGSnap1.JPG

prabunakil
Contributor III
Contributor III
Author

can u share again the qvw file. coz when i press the button, it do not give ant result. 

renuka_sasikumar
Creator III
Creator III

Its very simple create one variable vSelection,

use that in Button like

Snap.JPG

Then apply that in chart.

Snap1.JPG\

Hope this help

prabunakil
Contributor III
Contributor III
Author

my qlikview version is qlikview 9.00. seems like different with urs. 

renuka_sasikumar
Creator III
Creator III

Yes Mine is QlikView 12. Update it, Why using so old one.

prabunakil
Contributor III
Contributor III
Author

is with license. i seems like cannot update it. 

renuka_sasikumar
Creator III
Creator III

Download Qlikview November 2018 from here https://ap-a.demo.qlik.com/download/

U can go with desktop version, no license required. But you wont be able to my app. 

Just follow the step which I have given in the above replies.

  1. Create Variable
  2. Set Variable in TextObject.
  3. Apply condition in Chart Expression

 

prabunakil
Contributor III
Contributor III
Author

if using Qlikview 9.0, how we can perform this one as per ur scren shoot.