Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

simple set analysis

Hello,

A simple setanalysis questions:

If i want to see some data on a dimension but disregarding other dimensions how do i write that then?

Example:

DimensionsEmployee:

ID

Name

DimensionDate:

IDDate,

Year,

Month

Fact:

IDDate,

ID,

Amount

How do i then see amount on my selected employees, but they dont change when selecting year and month?

7 Replies
Not applicable
Author

in this case my amount should not be affected by year and month

bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

try sum({<Year=, Month=>} Amount)

israrkhan
Specialist II
Specialist II

Hi,

add Name your Dimension and Sum({$<Year=, Month=>}Amount) your expression.

Not applicable
Author

what happens if i put 1 infront

bbi_mba_76
Partner - Specialist
Partner - Specialist

With Sum({1<... you ignore all the selections on all the fields.

Not applicable
Author

so bascially this will show me all?

bbi_mba_76
Partner - Specialist
Partner - Specialist

Yes, if you use sum({1} Amount) all the selections (not only on Year and Month) will be ignored