topic Re: Only show a specific value in Table chart. in QlikView

Only show a specific value in Table chart.

Tue, 19 Feb 2013 23:26:02 GMT

Hi,

I am trying to create a chart that only shows a specific value from a field. For example a field "type" might have Declassified and Open. How can i make it so that table chart only shows Open? Is this possible without having to click in the field "Type."

Thank you for your help,

Re: Only show a specific value in Table chart.

erichshiino — Wed, 20 Feb 2013 00:35:40 GMT

Hi,

You can use set analysis in all you expressions.

For example, if your expressions are sum( Value) and sum (Qtd)

The adjusted expressions are sum ( {<type={Open}>} Value ) and sum ( {<type={Open}>} Qtd)

Hope it helps,

Erich

Re: Only show a specific value in Table chart.

Wed, 20 Feb 2013 01:05:55 GMT

You could also specify an expression for your dimension in a straight table chart, i.e.

IF(Type='Open',Type)

Then select to Supress when it's Null

See attached.

Re: Only show a specific value in Table chart.

Wed, 20 Feb 2013 16:22:19 GMT

Thanks,

That works, but I still get these '-' marks that changes the table chart. How can i get rid of those as well?

The first part works great.

Re: Only show a specific value in Table chart.

Wed, 20 Feb 2013 16:29:43 GMT

I clicked on supress null value and it worked to get rid of the '-'. Can one add multiple variables. For instance, Type = open and color=red?

Re: Only show a specific value in Table chart.

Wed, 20 Feb 2013 16:34:41 GMT

Yes, you can supply additional conditions, for example:

IF(Type='Open' And Color='Red',Type)

Re: Only show a specific value in Table chart.

erichshiino — Wed, 20 Feb 2013 17:04:07 GMT

Hi,

On set analysis you can also use multiple filters:

sum ( {<type={Open}, Color={Red}>} Qtd)

sum ( {<type={Open}, Color={Red, Blue}>} Qtd) -> meaning, type equals to Open and (Color equals to Red or Blue)

Regards,

Erich

Re: Only show a specific value in Table chart.

Wed, 20 Feb 2013 18:09:42 GMT

Thank you very much. It is working great.

Thank you Erich as well. Your solution works as well.

Nicholas