topic Re: Block Chart , multiple expressions in QlikView

Block Chart , multiple expressions

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Block Chart , multiple expressions

Arthur_Fong — Wed, 16 Oct 2019 05:02:28 GMT

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

Re: Block Chart , multiple expressions

qlikvw2019 — Wed, 16 Oct 2019 11:51:44 GMT

Thankyou. This worked as a Charm!

Re: Block Chart , multiple expressions

qlikvw2019 — Tue, 22 Oct 2019 16:00:49 GMT

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