Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Geetha123
New Contributor II

Qliksense toggle data results with dataset

Need help Please advise

Im looking for data to be filtered using data sets.

Basically its all coming from one table however it has column called type

Type has values ( 1,2,3,4,5,6,7)

I have to create a dataset A where it includes the data from table but however it should filter data for type = 1,2

similar other data set B where it should include data only for type 3,4

third data set  C which should include type all (1,2,3,4) but not (5,6,7)

please find attached picture  where A B C D are data sets and below is table with columns when I click on A below table should show results based on A similarly with B

 

Can we create such data sets with the script

As of now my script is select * from table 

2 Replies
Marcos_rv
Contributor II

Re: Qliksense toggle data results with dataset

why a data sets ??? Couldn't you use a container so that when you select a value like "A, B, C or D" you see a graph? You could do that using containers and on the condition that if a value is selected, a specific graph is displayed.

Geetha123
New Contributor II

Re: Qliksense toggle data results with dataset

Client request in the format what i attached 

they what to see the data to be changed in table when they click on data sets