Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist III
Specialist III

Re: Subsetting in a table

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

Highlighted
Specialist
Specialist

Re: Subsetting in a table

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

Highlighted
Specialist III
Specialist III

Re: Subsetting in a table

hope this helps you. See attached app and excel sheet

Highlighted
Not applicable

Re: Subsetting in a table

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