topic Re: Simple Set Analysis Question in QlikView

Simple Set Analysis Question

Qvmaster2019 — Fri, 10 Feb 2012 04:09:21 GMT

I am trying to run simple set analysis with two dimensions (Metric Name and Workweek). The logic is that :

If the Metric Name is "TOTAL Invoice Amount Paid", it should sum up all the total of specific 3 metrics but for some reason, it can't.

Please see attached.

Simple Set Analysis Question

jagan — Fri, 10 Feb 2012 05:00:14 GMT

Hi,

Try this expression it works.

=if([Metric Name]='TOTAL Invoice Amount Paid',

sum({<[Metric Name]={'Amount Invoice #1 - Paid ($K)','Sum of Invoice #2 - Paid ($K)','Invoice #3 - Paid ($K)'}>} TOTAL [TotalValue])+ 1,

Sum([TotalValue]))

Hope this helps you.

Regards,

Jagan.

Re: Simple Set Analysis Question

Qvmaster2019 — Fri, 10 Feb 2012 05:06:52 GMT

Hi Jagan,

Thanks for your reply.

This will not hold true if I have other workweek.

Regards,

dnatividad

Simple Set Analysis Question

jagan — Fri, 10 Feb 2012 05:12:59 GMT

Hi,

Try this,

=if([Metric Name]='TOTAL Invoice Amount Paid',

sum({<[Metric Name]={'Amount Invoice #1 - Paid ($K)','Sum of Invoice #2 - Paid ($K)','Invoice #3 - Paid ($K)'}>} TOTAL<Summary_Week> [TotalValue])+ 1,

Sum([TotalValue]))

Regards,

Jagan.

Re: Simple Set Analysis Question

Qvmaster2019 — Fri, 10 Feb 2012 05:36:54 GMT

Thanks Jagan!

Really appreciate your help.

Have a nice day, sir!

Simple Set Analysis Question

jagan — Fri, 10 Feb 2012 06:32:37 GMT

Hi,

Mark this Post as Answered, if it fixes your problem.

Regards,

Jagan.