Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subsetting in a table

Hi,


I'm new to Qlikview and am in the process of building my first application.

So far, I have loaded in data from 3 sources from excel, and concatenated them together using the script editor as they have consistent field names and formats, which enables concatenation. I have a field in that dataset called 'source', with values equal to 'A','B' or 'C', which enables me to identify which source particular rows in the data originate from.

For the sake of this example, I would like to build a straight table which users can use listboxes to drill down to. I would only like data to be displayed in this table where, in the input dataset, source = 'A'. I was wondering if anyone could shed light on how or where I would do this - I presume a conditional expression is required somewhere in the 'Chart Properties' window but I am not sure what that should be or where.

I hope this makes sense, and any advice would be greatly appreciated.

Thanks

Stephen

4 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Stephen,

this sounds like a job for Set Analysis.

An example, if you are wanting to show a Sum of your field InvoiceValue, use this expression

Sum({$<Source={'A'}>} InvoiceValue)

The Set in here (Source={'A'}) will limit the values in the expression to only those with a Source Of A

Marcus

richard_chilvers
Specialist
Specialist

Hi Stephen

You can 'filter' the data to be shown in your Chart in the Dimension tab of Chart Properties.

Something like IF(source='A', <dimension field>).

Of course, if you want the user to select the source code they wish displayed, you don't need to do this because the selection does it for you.

Be sure to check the box to suppress null values in this dimension.

HTH

Anonymous
Not applicable
Author

hope this helps you. See attached app and excel sheet

Not applicable
Author

All,

Thank you very much for your help with this. I have now managed to do this. Greatly appreciate all of your help.

Many thanks

Stephen