Block Chart , multiple expressions

[qlikvw2019]

Hello friends,

I am new to Qlikview. I have a block chart below. The Chart is sorted as per column ROOMSIZE , once the level is changed , I need the chart to show the sorting as per cubicle size .Attached is the qlikview file. Below is the screenshot.

Data

BLDG->ROOM->CUBICLE

BLDG	ROOM	ROOMSIZE	CUBICLE	CUBICLE_SIZE
BLDG1	ROOM1	500	CUB1	30
BLDG1	ROOM1	300	CUB2	40
BLDG1	ROOM3	400	CUB3	50
BLDG2	ROOM4	600	CUB6	60
BLDG2	ROOM5	800	CUB9	10
BLDG3	ROOM6	100	CUB10	20

Once the Block chart loads , the data is sorted based on the column ROOMSIZE . However when we select the room , the data is not displayed sorted as per CUBICLE_SIZE , its still sorted as per the ROOMSIZE.

On Selecting the bld1, it displays 2 rooms based on the roomsize , 

But now on selecting ROOM1 , below screenshot , CUB1 &CUB2 are sorted based on the ROOMSIZE ,  How can i have them  sorted based on the cubicle_size

[Arthur_Fong · Accepted solution]

There you go,

Use one expression will do:

if(GetSelectedCount(BLDG)>=1 and GetSelectedCount(ROOM)>=1,MAX(CUBICLE_SIZE),MAX(ROOMSIZE))

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[qlikvw2019]

Thankyou. This worked as a Charm!

[qlikvw2019]

Hi,

I have another issue on the same chart , could you check this post?

https://community.qlik.com/t5/New-to-QlikView/Caption-on-Block-Chart/m-p/1638237#M382359

Thanks