topic Re: Bucket Multiple Expression in QlikView

Bucket Data Multiple Expression

Fri, 04 Oct 2013 13:20:12 GMT

Hello Every one,

I am trying to do Bucketing on multiple expression.

Please see below table. Count and Sum of revenue has other set conditions in the expressions.

Count: No of Clients who has revenue >10MM in first row for 2013 and 2012

Sum Of rev: Sum of Revenue of 3 Client in first row for 2013 and 2012

I have little idea as under

1. Use class function but don't know how to use with multiple expressions like count ans sum

2. If condition for each expression, which will be very complex.

Please help with your ideas. I tried looking in forum but could not find something like this.

I am not sure if this is possible simple way

Thank you in advance.

Dev

Fri, 04 Oct 2013 15:42:56 GMT

Any Help please

Gysbert_Wassenaar — Fri, 04 Oct 2013 15:44:52 GMT

Please read these two documents:

Fri, 04 Oct 2013 17:26:20 GMT

Hi G Wassenaar

Please see attached sample data and qvw and expected output file. I am not getting expected output for revenue. The counts are coming correctly.

Hope this helps

Thank you for the feedback

Dev

Fri, 04 Oct 2013 19:04:24 GMT

Hi Dev

I made modification to your formula in 2013/2012 charts SumOf Rev column. I also added text object with formula.

Hope this is what you are looking for.

Fri, 04 Oct 2013 19:08:06 GMT

Devang,

Thank you so much. That is correct result.

Is there a Dynamic way I can get 2012 and 2013 in one chart?

Fri, 04 Oct 2013 19:31:56 GMT

Hi Dev

Do Something like this. Hope this help