Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to display 3 separate Straight Tables of data on one sheet. See the data loaded below.
Each table will display the Comments associated with each Division (the tables are split be Division).
How do I filter each table to only display the Comments from the associated Division?
Thanks
Number | Division | Comment |
1 | Division 1 | Division 1; Comment 1 |
2 | Division 1 | Division 1; Comment 2 |
3 | Division 1 | Division 1; Comment 3 |
1 | Division 2 | Division 2; Comment 1 |
2 | Division 2 | Division 2; Comment 2 |
3 | Division 2 | Division 2; Comment 3 |
1 | Division 3 | Division 3; Comment 1 |
2 | Division 3 | Division 3; Comment 2 |
3 | Division 3 | Division 3; Comment 3 |
I'd suggest to use set analysis with the filter on the field Division.
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
hi Jeff,
first in your load script split Comment column using subfield function.
subfield(Comment,';'2) as comment
subfield(Comment,';'1) as division
then create 3 tables and use set analysis to identfy only 1 division.
Oleg:
I was thinking the same thing, however I am struggling with where to put the Set Analysis string (and not sure of the context).
Jeff
Saurabh:
I'm not familiar with "subfield" and don't really understand why using it. It seems if I put the Set Analysis in the correct location (The data in the Comment Column is sample data. I just used "Division 1; Comment 1" as example data.
In which property should I put the string <Division = {'Division 1'}> (if that is the correct string)
Jeff
Well, it depends on how you'd like to show your comments. If these are expressions, and there is another dimension (Number?) that identifies each comment uniquely, then you can use Set Analysis with the Only() function:
Only({<Division={Div1}>} Comment)
If Comment should be a Dimension, then I'd use a hidden expression that could help you filter the data, for example:
Count({<Division={Div1}>} Comment)
All you need is to find an aggregation function that can accept your Set Analysis.
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense