topic Re: How to an expression that is based on a conditional dimension? in QlikView

How to an expression that is based on a conditional dimension?

chiranjivdas — Fri, 02 Jan 2015 22:17:09 GMT

I have a pivot table by accounts and quarters across the top.

I need to create a view that has the current quarter only, so I have used this expression:

if([Fiscal Quarter]='2015-4',sum([USD Product Bookings]),'0')

Now, I want to sort, the values in descending order, but I am unable to. I tried Sort - Expression - Descending - =if([Fiscal Quarter]='2015-4',sum([USD Product Bookings]),'0')

but it did not work.

Thanks for your help.

Re: How to an expression that is based on a conditional dimension?

rwunderlich — Fri, 02 Jan 2015 22:23:15 GMT

Have you tried sort by Y value?

-Rob

Re: How to an expression that is based on a conditional dimension?

chiranjivdas — Fri, 02 Jan 2015 22:26:05 GMT

Thank you, Rob

Re: How to an expression that is based on a conditional dimension?

Anonymous — Sat, 03 Jan 2015 03:25:20 GMT

HI Use the expression like

Sum(if([Fiscal Quarter]='2015-4',[USD Product Bookings],'0') )