Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Drill Group in Set Analysis

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

1 Solution

Accepted Solutions

Re: Drill Group in Set Analysis

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


talk is cheap, supply exceeds demand
2 Replies
calvindk
Contributor III

Re: Drill Group in Set Analysis

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

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


talk is cheap, supply exceeds demand
Community Browser