topic Re: set analysis inside an aggregated dimension in QlikView

set analysis inside an aggregated dimension

Anonymous — Wed, 12 Aug 2015 08:20:27 GMT

Hi everyone,

I have the following aggregation as one of my dimensions:

=aggr(sum([Total OUL]),[Voucher Product Code])

What I would like to do is to put set analysis inside of this expression.

I have the following I would like to add as set analysis:

day = $(vmaxday), where vmaxday is a variable I declared which states max(day)

How would the final output look like?

Any help will be much appreciated.

Thanks,

Stefan

Re: set analysis inside an aggregated dimension

settu_periasamy — Wed, 12 Aug 2015 08:27:10 GMT

May be this

=aggr(sum({<day ={'$(=vmaxday)'}>}[Total OUL]),[Voucher Product Code])

Re: set analysis inside an aggregated dimension

Anonymous — Wed, 12 Aug 2015 08:37:37 GMT

What I have at the moment is:

=aggr(sum({<[Day Date]= {'$(vMaxDayDate)'}>} [Total OUL]),[Voucher Product Code])

but it brings nothing back.

I also tried

=num(aggr(sum({<[Day Date]= {'$(=vMaxDayDate)'}>} [Total OUL]),[Voucher Product Code]),'##,##0')

but with no luck

Re: set analysis inside an aggregated dimension

settu_periasamy — Wed, 12 Aug 2015 09:27:15 GMT

check the variable =vMaxDayDate giving the correct value or not in the text box.

can you post the sample?

Re: set analysis inside an aggregated dimension

Anonymous — Wed, 12 Aug 2015 09:31:03 GMT

Hi,

I found that my date column wasnt seen as a date but instead as a string. when displaying vmaxdaydate in a textbox it came back as a blank. because the variable was declared as max(day).

I changed it around a bit and it works perfectly now. thank you so much for the feedback