topic Re: Drill Group in Set Analysis in QlikView

Drill Group in Set Analysis

Mon, 27 May 2013 20:36:04 GMT

Hi All,

I have a set analysis formula I am using along the lines of:

sum({<Date = {"*"} >} Price)

I would like to replace the static Date in the formula with a Drill group. Does anyone know the correct syntax to replace the Date dimension with a "GetSelectedField(Date_Drill)"?

Any help is much appreciated!

Thanks

Re: Drill Group in Set Analysis

calvindk — Tue, 28 May 2013 01:03:49 GMT

Not sure if you can make the GetSelectedField work inside the set analysis, but you can surely do different set analysis based on the field.

Something like this:

If(GetCurrentField(DateDrill) = 'Date1', sum({<Date1 = {"*"} >} Price),

If(GetCurrentField(DateDrill) = 'Date2', sum({<Date2 = {"*"} >} Price),

3))

Re: Drill Group in Set Analysis

Gysbert_Wassenaar — Tue, 28 May 2013 08:58:20 GMT

This should work: sum({<$(=GetSelectedField(Date_Drill))= {"*"} >} Price)