topic Re: How to convert BarChart to BlockChart ? in QlikView

How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 09:09:41 GMT

hi to all ,

i have usual BarChart with year dimension and 2 measurs, looks like that :

i need to convert it to BlockChart , with 2 parts with the 2 colors blue and green ( i dont need to see the year )

, how can i do this ? thanks ?

Re: How to convert BarChart to BlockChart ?

Chanty4u — Sun, 27 Mar 2016 09:13:49 GMT

can u share sample app?

Re: How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 11:45:18 GMT

here it is , Similar to the first example :

thanks.

Re: How to convert BarChart to BlockChart ?

Chanty4u — Sun, 27 Mar 2016 11:51:01 GMT

is this?

Re: How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 12:05:51 GMT

no Chanty , I NEED SOMETHING THAT LOOKS SIMPLE LIKE :

NOT COMPLICATE LIKE ( years of regular ) :

- 1 BlockChart - 2 parts ONLY .

Re: How to convert BarChart to BlockChart ?

Kushal_Chawda — Sun, 27 Mar 2016 12:10:31 GMT

like this?

Re: How to convert BarChart to BlockChart ?

sunny_talwar — Sun, 27 Mar 2016 12:34:56 GMT

In addition, if you would like to make selection in one of those blocks, then ValueList() as dimension won't work, in that case you can create an Island Inline table in the script and use that as your dimension:

Table:

LOAD year,

regular,

amazing,

amount

FROM

Community_211021.xls

(biff, embedded labels, table is Sheet1$);

Dim:

LOAD * Inline [

Dim

];

Dimension: Dim

Expression: (Same as what Kush has provided) just using Dim

=Pick(Dim,

Sum({$<regular={1}>}amount),

Sum({$<amazing={1}>}amount))

If not selection would be necessary you should be good using Kush's solution

Re: How to convert BarChart to BlockChart ?

Kushal_Chawda — Sun, 27 Mar 2016 12:38:37 GMT

sunindia

looks like you love the PICK function

Re: How to convert BarChart to BlockChart ?

Kushal_Chawda — Sun, 27 Mar 2016 12:41:53 GMT

Re: How to convert BarChart to BlockChart ?

sunny_talwar — Sun, 27 Mar 2016 12:44:13 GMT

I have been using it more often then not for situations like these ever since I have learnt their use from you Kush‌

Re: How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 13:26:42 GMT

hi kush - your answer is a big help for us - THANKS!!

Re: How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 13:28:14 GMT

HI - THE PICK IS THE THING - THANKS !!

Re: How to convert BarChart to BlockChart ?

yanivvl0 — Sun, 27 Mar 2016 13:30:24 GMT

sorry - but i cant mark as correct answer ... if u know how pls tell me - regards.

Re: How to convert BarChart to BlockChart ?

Kushal_Chawda — Sun, 27 Mar 2016 13:33:48 GMT

Your welcome

Re: How to convert BarChart to BlockChart ?

Saravanan_Desingh — Sun, 27 Mar 2016 15:06:59 GMT

Hi Sunny.

This is really an inspiring trick. I was using Pick-Dim only in Dimensions and I learnt even this can be used in Expressions.

I have a question here. In your example, both the blocks shows 'regular'. Though the results are for 'amazing' & 'regular', still I'm seeing 'regular' if I hover my cursor.

Do you think, this can be fixed.