topic Re: How can shorten this expression in QlikView

How can shorten this expression

Tue, 12 Feb 2013 14:52:45 GMT

I have written following expression using SET where i want the total of quantity based on user selection and if user dont select any country then it should be as select all i am looking forward to shorten this expression

=if(count(GetCurrentSelections(Country)) <>0 , sum({$ <Country = {$(=getcurrentselections(Country,','))}>} Quantity),sum({$ <Country = {'*'}>} Quantity))

Thanks & Regards

Prash

Re: How can shorten this expression

avastani — Tue, 12 Feb 2013 15:02:46 GMT

isn't this redundant? QlikView does what you are asking above naturally based on user clicks. you don't have to specify the selections. just a simple SUM(Quantity) should be fine,

Re: How can shorten this expression

Tue, 12 Feb 2013 15:12:17 GMT

Yes but i want to add more dimensions such as top 5 Products / country

Re: How can shorten this expression

avastani — Tue, 12 Feb 2013 15:14:25 GMT

Doesn’t matter. That’s QlikView’s in built engine doing it all for you. You can create listboxes and click in it and it will report the associated SUM(Quantity) so you don’t have to worry about loading the expression with set analysis.

In QV 11 you can use the Dimension Limits tab to do the Top(X) analysis,

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: How can shorten this expression

Tue, 12 Feb 2013 15:16:17 GMT

You can store lengthy expressions in a variable and instead os expression you can call that perticular variable.