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
tharanikannan
Contributor III
Contributor III

Hi,

You can achieve this by checking "Drop down Select" option in presentation tab. Select the dimension and check the option. please find the screenshot for your reference below,

 

Thanks,

Tharani.

prabunakil
Contributor III
Contributor III
Author

Hi my drop down is grey off. 

Capture.JPG

tharanikannan
Contributor III
Contributor III

Hi,

I believe that, drop down selects are applicable for dimensions not for measures .

prabunakil
Contributor III
Contributor III
Author

My Gross, Net, Return is expression. So how can i achieve that?

Anil_Babu_Samineni

Since These are 5 measures and effect to all Dimensionality. not sure the way is existing. But work around may be attachment.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prabunakil
Contributor III
Contributor III
Author

Hi it did not work.

renuka_sasikumar
Creator III
Creator III

I hope I got your question.

You can create few buttons by setting a variable to it and apply conditional enabling in Expression.

For eg. if the user selects Net, it will show only Net Sales.

 

Hope this helps.

Regards,

Renuka S

prabunakil
Contributor III
Contributor III
Author

Hi, do you have example. Yes this is the configuration i required. 

renuka_sasikumar
Creator III
Creator III

Attached QVW FYI, Let me know if anything.

Regards,

Renuka S