Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lukegilligan
Contributor III
Contributor III

Filtering Straight Table by Text Value

I am fairly new to Qlikview and have just completed the Designer & Developer training, but I am still struggling with pre filtering data.

I am trying to build a dashboard for use with our higher level execs that will be pre filtered to show the right data in the tables.

I have a straight table that lists details service requests we have in the system and it is working as expected when I click on the value in a list box it filters the table on that value.

What I need is for the execs to not have to click the button to filter the data.

From what I understand I need to use Set Analysis to do this, however all I am finding is examples on how to use Set Analysis on calculations, not on text values.

I have attached a sample set of data in a QVW table. As an example, I would like to filter this table based on Request Type being Complaints. Hopefully, once I work out how to pre filter this data I will be able to then use the same principals to build other pre filtered charts and graphs.

Any help would be much appreciated.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

You can use calculated dimension, or you can use set analysis... I have done it in three different ways... check them out

View solution in original post

2 Replies
sunny_talwar

You can use calculated dimension, or you can use set analysis... I have done it in three different ways... check them out

lukegilligan
Contributor III
Contributor III
Author

Thanks Sunny, you are a life saver, I ended up using the IF statement on the SR number. For some reason when I tried to use the ONLY function in my real data it wouldn't filter.

Thanks again,