topic Re: display specific data in straight table in QlikView

display specific data in straight table

Tue, 01 Jul 2014 03:56:08 GMT

Hi, is there a way to display specific data in straight table? for example, display only data for site a,b and c out of many different sites? What is the script to put in 'expression'? Thanks.

Re: display specific data in straight table

jagan — Tue, 01 Jul 2014 04:18:51 GMT

HI,

Try like this, in expression define set analysis to display only specific values

=Sum({<site={'a', 'b', 'c'}>} MeasureName)

Regards,

jagan.

Re: display specific data in straight table

Tue, 01 Jul 2014 04:22:24 GMT

Hi,

Instead of expression, Under Dimension Tab

You can add Calculated dimension like below:

if(Site='a' or Site='b' or Site='c',Site)

Hope it may help.....

Re: display specific data in straight table

its_anandrjs — Tue, 01 Jul 2014 04:32:16 GMT

You can achieve this by calculated dimension or SET expression in the expression.

1. By calculated dimension

if(Match(site,'a','b','c'),site)

//And select suppress when value null

2. By SET expression

Sum( {< site = {'a','b','c'} >}Measure)