Nested set analysis difficulty

Mon, 25 Aug 2014 16:13:40 GMT

Hello,

I have a pivot table in my application with the following expression:

=Sum ({$<MainDate_YYYY={$(=max(MainDate_YYYY)-1)},[%DistributionChannel] = {"<>01"}>}[#OrdLine_Net Value (€)])

I would like to add somewhere in this set analysis that [Ord_Sales Document Category]<>'K'.

I tried the following syntax: =Sum ({$<MainDate_YYYY={$(=max(MainDate_YYYY)-1)},[%DistributionChannel] = {"<>01"},[Ord_Sales Document Category] = {"<>K"}>}[#OrdLine_Net Value (€)]), but with no luck.

I also tried adding a calculated dimension like this: =Aggr(Only({$-<[Ord_Sales Document Category] ={"K"}>}[Ord_Sales Document Category]),[Ord_Sales Document Category]) which worked, but I can't hide the column in a pivot table.

Any idea, please?

Re: Nested set analysis difficulty

Anonymous — Mon, 25 Aug 2014 16:27:13 GMT

Try this (notice the minus sign):

[Ord_Sales Document Category]-={'K'}

Re: Nested set analysis difficulty

Mon, 25 Aug 2014 18:19:06 GMT

Yes, thank you! It works. I tried all sort of things, but I still have a lot to study...

Re: Nested set analysis difficulty

Anonymous — Mon, 25 Aug 2014 18:20:20 GMT

Me too

topic Re: Nested set analysis difficulty in QlikView

Nested set analysis difficulty

Re: Nested set analysis difficulty

Re: Nested set analysis difficulty

Re: Nested set analysis difficulty