Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Or
=Sum(TOTAL<Year, Day, Month, Week> Value)
Thank you very match it worked!
בתאריך 27 בינו' 2016 23:24, "swuehl" <qcwebmaster@qlikview.com> כתב: