Dynamic dimension

dwhanand — Thu, 11 May 2017 09:52:02 GMT

Hi All,

I have a sample data as below

ID old_val new_val date

101 A B 01/01/2017 10:40:00

101 B C 01/01/2017 10:45:00

101 C B 05/01/2017 09:45:00

Expression -> Count(distinct ID)

But dimension should be old_val, new_val i.e

Without applying date

old_val (min date of old value) as A and new_val (max date of new_val) as B

In case if i apply date as 01/01/2017 then old_Val as A and new_val as C

I used calculated dimension logic as

old_val -> aggr(min(old_val) ID) for

new_val -> aggr(min(new_val) ID) for

I dont know how to apply the max date for above cal dimension

Actual requirement

Logic should be count of ID with first dimension as old_val group by min date , ID and second dimension as new_val group by max date, ID

topic Dynamic dimension in QlikView

Dynamic dimension