topic Re: Subsetting in a table in QlikView

Subsetting in a table

Tue, 21 Jul 2015 12:27:35 GMT

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

Re: Subsetting in a table

marcus_malinow — Tue, 21 Jul 2015 15:24:34 GMT

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

Re: Subsetting in a table

richard_chilvers — Tue, 21 Jul 2015 15:26:59 GMT

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

Re: Subsetting in a table

Anonymous — Tue, 21 Jul 2015 15:36:17 GMT

hope this helps you. See attached app and excel sheet

Re: Subsetting in a table

Wed, 22 Jul 2015 07:05:33 GMT

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