topic need expression in QlikView

need expression

Tue, 07 Jan 2014 14:10:04 GMT

Hi all,

I have a scenario like these here i am having "week-sk" and "day_sk". i want to show for a particular week_sk the max day_sk

should be day1 and the second max day_sk should be day2 like that...here iam attaching the file

swuehl — Tue, 07 Jan 2014 14:13:10 GMT

Not sure if I understand, maybe just create a chart with dimension week_sk and as expression

=max(day_sk)

MK_QSL — Tue, 07 Jan 2014 14:53:28 GMT

=Aggr(Max(Day_sk),week_sk)

Wed, 08 Jan 2014 05:59:58 GMT

Hello Kannuri,

Can you please look into the attachment.

Thanks,

Angad

Wed, 08 Jan 2014 06:58:45 GMT

Hi,

Pls. Use Aggr(Max(Day_sk),week_sk) in expression and week_sk in dimention.

Regards,

Mayank

Wed, 08 Jan 2014 07:15:41 GMT

Hi Nagaraju,

Please find the below attached file for the solution.

Regards,
Santhosh G

Wed, 08 Jan 2014 09:33:38 GMT

Hi Angad Singh,

Thanks for your response but i want to show for the rank1 the days should be day5 and for rank 2 the day should be day 4.. like that

Regards,

Nagaraju

Tue, 14 Jan 2014 07:40:27 GMT

Hello Kannuri,

Please find the attached solution.

We have rank the day twice to get the desired results.

Please let me know, if it meets your expected results or anything else is required.

Thanks,

Angad