topic Re: Ignore specific Dimension selection in QlikView

Ignore specific Dimension selection

Sun, 30 Mar 2014 08:38:47 GMT

Hi All

i am displaying tickets per month.

Month as dimension, count ticket as expression.

i would to make a fixed table with all tickets per month so that if i selected a specific month, all the charts should be affected except that table. and this is for the month dimension only; i mean all the other selections should be applied.

e.g

Month, Tickets

Jan 3000

Feb 4000

Mar 3000

if i selected Feb in need to have the same above table

Re: Ignore specific Dimension selection

whiteline — Sun, 30 Mar 2014 08:44:35 GMT

Hi.

Use set analysis (refer to help).

Sum({<Month=>} Tickets)

Re: Ignore specific Dimension selection

Sun, 30 Mar 2014 08:56:00 GMT

Hi whiteline,

set analysis will affect the # of tickets not the Month name.

i need to have all the months listed.

Re: Ignore specific Dimension selection

whiteline — Sun, 30 Mar 2014 09:08:18 GMT

So you don't even bother to try ?

Re: Ignore specific Dimension selection

Sun, 30 Mar 2014 09:47:22 GMT

thanks whiteline

i applied it on one expression although i have many expressions in the same chart. but i when i made a sample file, i understood.

thanks a lot again.

i need to read deeply what is set analysis.

Re: Ignore specific Dimension selection

whiteline — Sun, 30 Mar 2014 09:53:26 GMT

There are good examples of set analysis, refer to QV help.