topic Re: simple set analysis in QlikView

simple set analysis

Tue, 08 Oct 2013 12:09:48 GMT

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:

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?

Tue, 08 Oct 2013 12:11:57 GMT

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

bbi_mba_76 — Tue, 08 Oct 2013 12:20:08 GMT

Hi,

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

israrkhan — Tue, 08 Oct 2013 12:22:24 GMT

Hi,

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

Tue, 08 Oct 2013 12:24:40 GMT

what happens if i put 1 infront

bbi_mba_76 — Tue, 08 Oct 2013 12:28:24 GMT

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

Tue, 08 Oct 2013 12:29:58 GMT

so bascially this will show me all?

bbi_mba_76 — Tue, 08 Oct 2013 12:34:37 GMT

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