Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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?

Tags (2)
7 Replies
Not applicable

Re: simple set analysis

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

bbi_mba_76
Valued Contributor

Re: simple set analysis

Hi,

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

israrkhan
Valued Contributor II

Re: simple set analysis

Hi,

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

Not applicable

Re: simple set analysis

what happens if i put 1 infront

bbi_mba_76
Valued Contributor

Re: simple set analysis

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

Not applicable

Re: simple set analysis

so bascially this will show me all?

bbi_mba_76
Valued Contributor

Re: simple set analysis

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

Community Browser