topic Re: Error in Script !! in QlikView

Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 07:41:38 GMT

HEy,

I want Sum Of values for customers whose values is greater than 1000.

I ahve used following expression , but nothing comes in starightt able.

What to do ??

Sum({<Customers = {"=rank(Sum(Values),4)>= 1000"}>}Values)

Thanks

Re: Error in Script !!

Colin-Albert — Mon, 12 Jan 2015 07:49:53 GMT

Try

Sum({<Customers = {"=$(=rank(Sum(Values),4)>= 1000)"}>}Values)

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 07:52:41 GMT

No result yet !!

Re: Error in Script !!

maleksafa — Mon, 12 Jan 2015 08:01:04 GMT

=rangesum(if(sum(Values)>1000,sum(Values)))

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 08:04:16 GMT

Hey thanks ,

I got it but i want the values to be shown in ascending order. How to do it ??

My output is :

432

444

654

How to do this ??

Re: Error in Script !!

maleksafa — Mon, 12 Jan 2015 08:06:52 GMT

if you are using a straight table, simply go to the sort tab, select the expression and promote it to the top and then check only the numeric value with ascending order. you can remove the 'allow interactive sort' so that the users will not modify the sort later on.

Re: Error in Script !!

its_anandrjs — Mon, 12 Jan 2015 08:07:19 GMT

Hi,

For sorting use the same expression in the sort order in the expression

Regards

Anand

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 08:14:20 GMT

Hey thanks. It works . But why to uncheck Interactive Sort ??

thanks

Re: Error in Script !!

maleksafa — Mon, 12 Jan 2015 08:17:28 GMT

when you check the interactive sort, it will allow the user to change the sort by clicking on the expression column (you will say a small arrow next to the column name) so if you don't want the user to change the sorting you should uncheck it.

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 09:18:45 GMT

Hey ,

Sorry but i didn't get you.

Did you meant to say that if i want sorting to be done my way then i should check the "Interactive Sort" option.

Is it so ?

Thanks

Re: Error in Script !!

maleksafa — Mon, 12 Jan 2015 10:00:19 GMT

the interactive sort will allow the user to change the sort by double clicking on the column name, in your case the sorting is done based on total sales ascending order, now if the interactive sort is checked you can go to your chart and double click on the sales column (on the label name) and you will see that the sorting will change from ascending to descending. if you want to disable this feature you should uncheck the interactive sort option.

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 10:06:15 GMT

Hey ,

Thanks. Got the point.

Are you on Linkedin ?

Re: Error in Script !!

maleksafa — Mon, 12 Jan 2015 10:25:44 GMT

sure, Malek safa from lebanon.

Re: Error in Script !!

nikhilgarg — Mon, 12 Jan 2015 11:01:47 GMT

Hey thanks and on whatsapp?