topic Re: calculated dimensions - ignore selections in QlikView

calculated dimensions - ignore selections

idogridish2 — Wed, 27 Jan 2016 20:25:18 GMT

Hello everyone,

I have a pivot table that has five dimensions,

and I want to ignore only one dimension when selecting.

photo attatched.

the name of the field is [campaign desc].

i want to be able to select dates but not the [campaign desc].

only filer by year month week and day

thanks in advance.

swuehl — Wed, 27 Jan 2016 21:23:56 GMT

Not sure if I understand. How does your expression in the pivot table looks like?

In general, you can ignore selections in fields using set analysis:

=Sum({<FIELDTOIGNORE= >} Value)

and you can ignore dimensions in a chart using TOTAL qualifier, by listing only dimensions you want to consider;

=Sum(TOTAL Value)

=Sum(TOTAL<Year, Day, Month, Week> Value)

idogridish2 — Wed, 27 Jan 2016 23:19:35 GMT

Thank you very match it worked!

בתאריך 27 בינו' 2016 23:24,‏ "swuehl" <qcwebmaster@qlikview.com> כתב: