Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
safahsc
Contributor
Contributor

PIVOT - FILTER ONE DIMENSION BUT SHOW IN ALL

Hi,

I'm new to qliksense. I have dimension "X" on my pivot table. And I'd like to filter my dimension in measure set expression but show the outcome in all rows.

NOTE: XYZ is a variable.

I try  (SUM({<A= {'XYZ'}>}  CARDS)  or (SUM({$<A= {'XYZ'}>}  CARDS) but pivot rows are filtered only for  row A.

Assume that (SUM({<A= {'XYZ'}>}  CARDS) = 10, I want table like this;

A 10

B 10

C 10

but I get;

A 10

Thanks for help.

Labels (4)
1 Reply
Vegar
MVP
MVP

try using TOTAL:

SUM({<A= {'XYZ'}>} TOTAL  CARDS)