topic Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression? in QlikView

Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Wed, 09 Jul 2014 07:16:16 GMT

Hi all,

I have a question like what I said on the topic, I feel it is strange.

I want to calculate the most qty store per vip. and I have data like this:

and I did a chart to calculate that using aggr firstsortedvalu in dimension like this:

but the expression(QTY) is not 8 for A, but 11 for A, so I feel it is strange, why the second dimension doesn't affect the expression?

or do I need to use other statement to calculate that?

please help, and the attached file is the qvw. Thank you so much!

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

VishalWaghole — Wed, 09 Jul 2014 07:28:40 GMT

Hi Changjun,

Please find attached QVW application,

I have created one more chart in your application.

Hope it will help you.

-- Regards,

Vishal Waghole

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

VishalWaghole — Wed, 09 Jul 2014 07:31:41 GMT

just try with this expression :

=sum(aggr(sum(QTY),VIP,STORE))

-- Regards,

Vishal Waghole

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Wed, 09 Jul 2014 09:35:30 GMT

Hi vishal,

thank you for your answer,but I just want to show one store per vip,

I just want to show the most qty store, or the expression doesn't make any sense, so do you have any other idea?

thank you!

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

VishalWaghole — Wed, 09 Jul 2014 09:39:19 GMT

Hi Changjun,

I didn't understand your requirement,

so can you please roughly draw what type of output you want.

-- Regards,

Vishal Wagole

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Wed, 09 Jul 2014 10:01:59 GMT

this:

Re: Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

Anonymous — Wed, 09 Jul 2014 10:04:24 GMT

See attachement

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

er_mohit — Wed, 09 Jul 2014 10:21:53 GMT

See the attached file

see in script also

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Thu, 10 Jul 2014 03:08:03 GMT

Hi Satyadev,

thanks for your help, but I think the result is not what I want, I hope the result is the same with my screenshot above.

Re: Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

jagan — Thu, 10 Jul 2014 03:48:04 GMT

Hi,

Please find attached file for solution. Used dimension limits for the second dimension.

Regards,

Jagan.

Re: Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

Anonymous — Thu, 10 Jul 2014 04:09:37 GMT

Hi,

Please check the enhanced version. Hope this helps you.

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Thu, 10 Jul 2014 05:30:35 GMT

Hi Mohit,

thanks for your help, the result is what I want, but I don't want to change the script, do you have any other idea to solve this problem?

thank you !

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Thu, 10 Jul 2014 05:40:03 GMT

Hi Satyadev,

thanks again, the result is great for me, but actually I don't want to modify the script, I think Jagan's method works.

thank you so much,

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

uacg0009 — Thu, 10 Jul 2014 05:41:44 GMT

Hi Jagan,

thank you so much for you answer, that's what I want. But if I change the request about most qty to most order to also calculate the sum(qty), does that will work?

Re: Why the aggr(firstsortedvalue) dimension doesn't affect the expression?

jagan — Thu, 10 Jul 2014 06:16:48 GMT

Hi,

This will work just change the expression.Count(ORDER) it works.

Regards,

Jagan.