Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
josemaria_cabre
Contributor III
Contributor III

help with set analysis

Hi everyone!

Let's imagine I have following dimensions in my model:

Market
Product_group
Department

...+ 100 more dimensions

and this measures:
units
price

If I want to create a KPI which must not be filtered by e.g. 'Market' and 'Department', I'd use this formula:

Count({<Market = , Department= >} units)

Which formula should I use, if I want units to be filtered ONLY by dimension 'Product group', ignoring the +100 dimensions in my model? Is that possible?

Thanks in advance,
Jose.

 

 

Labels (2)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

Try this:

Count({1<[Product group]= $::[Product group]>}units)

 

Source : Set Analysis: Ignore All Selections except for one field

View solution in original post

2 Replies
micheledenardi
Specialist II
Specialist II

Try this:

Count({1<[Product group]= $::[Product group]>}units)

 

Source : Set Analysis: Ignore All Selections except for one field

View solution in original post

josemaria_cabre
Contributor III
Contributor III
Author

Worked perfect!

Thank you Michele