topic Re: Multi Dimensional Bands in QlikView

Multi Dimensional Bands

rajeshvaswani77 — Thu, 04 Jul 2013 17:23:11 GMT

Hi All,

I have the below set of data

BU,UCR,Amount

BU1,U1,10

BU1,U2,100

BU2,U3,50

BU3,U4,200

would like to display display the data in the table with bands as below (segregated at the level of BU and UCR, Note that BU1 has two UCR's falling in to two different bands.)

BU	<15	15 - 50	50 - 100	100 - 200
BU1	1	0	1	0
BU2	0	1	0	0
BU3	0	0	0	1

Current result is shown as BU1 showing count of 2 under Band 100 - 200. Which we do not want.

Attached is the attachment that has the scenario.

Could you please help on this?

thanks,

Rajesh Vaswani

Re: Multi Dimensional Bands

Gysbert_Wassenaar — Thu, 04 Jul 2013 17:50:37 GMT

See attached qvw.

Re: Multi Dimensional Bands

jagan — Thu, 04 Jul 2013 19:38:17 GMT

Hi,

Rajesh,

Please find attached file for solution.

Regards,

Jagan.

Re: Multi Dimensional Bands

rajeshvaswani77 — Thu, 11 Jul 2013 17:28:16 GMT

Hi Gysbert,

Thanks for your Help. In continuation to this, below table is the result that we are expecting.

BU	<15	15 - 50	50 - 100	100 - 200	>200
BU1	0	0	1	1	1

The data has

BU,UCR, TR,CDate,Amount

BU1,U1,TR1,01/01/2013,10

BU1,U1,TR7,01/02/2013,50

BU1,U2,TR2,01/02/2013,100

BU1,U2,TR8,01/03/2013,10

BU1,U6,TR3,01/08/2013,250

Sum of U1 for BU1 will be 60

Sum of U2 for BU1 will be 110

Sum of U6 for BU1 will be 250

The qvw file for this example is attached.

thanks,

Rajesh Vaswani

Re: Multi Dimensional Bands

Gysbert_Wassenaar — Thu, 11 Jul 2013 18:01:57 GMT

See attached qvw

Re: Multi Dimensional Bands

rajeshvaswani77 — Fri, 12 Jul 2013 15:02:59 GMT

Thank You, Gysbert. The solution works perfectly.

One last question I have is on how I could filter based on these Bands:

<15

15 - 50

50 - 100

100 - 200

>200

Is there a way I can setup a Multi Box or a List Box with these bands. On selection of a band, I need to see just the data for the selected band(s) on the table.

thanks,

Rajesh Vaswani