topic Re: Multiple Boolean flags bar chart in QlikView

Multiple Boolean flags bar chart

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

Hi all,

Quite new to Qlik so bear with me if this is an easy one. I have data that looks like this:

Unique ID	Customer	Region	Attribute 1	Attribute 2	Attribute 3	Flag 1	Flag 2	Flag 3
1	A	E	a	a	b	Y	N	Y
2	A	G	c	d	e	N	N	Y
3	B	F	c	d	b	N	N	N
4	C	F	c	c	c	Y	Y	N
5	D	G	d	f	d	N	N	N

The flags are created in the script editor using logical statements based on Attributes 1, 2 and 3 (it might be more attributes in my actual data set).

e.g. Flag 1 = Y if Attribute 1 = Attribute 2

Flag 2 = Y if Attribute 2 = Attribute 3

Flag 3 = Y if Attribute 2 < Attribute 3

I am able to create a stacked bar chart that counts the 'Y' (excluding the 'N') per Flag and per Region. However, what I would like achieve is the flag being as well as the region being reflected in the current data selection upon clicking on a given flag's count for a given region.

Hope this makes sense. Thanks for your help.

Re: Multiple Boolean flags bar chart

sunny_talwar — Tue, 05 Jun 2018 11:56:38 GMT

I am not entirely sure I understand, but I think you might need The Crosstable Load function to transform your data and then create your chart

Re: Multiple Boolean flags bar chart

jyothish8807 — Tue, 05 Jun 2018 12:02:33 GMT

Hi Camilie,

Is this what you are looking for ? (ref attached)

CrossTable(Flag, Data, 6)

LOAD [Unique ID],

Customer,

Region,

[Attribute 1],

[Attribute 2],

[Attribute 3],

[Flag 1],

[Flag 2],

[Flag 3]

FROM

[https://community.qlik.com/thread/303789]

(html, codepage is 1252, embedded labels, table is @1);

Re: Multiple Boolean flags bar chart

Anonymous — Tue, 05 Jun 2018 14:25:08 GMT

Thank you! However, upon drilling into the data (e.g. clicking on the graph) it doesn't reflect the 'Y' of a given flag in the current selection.

Re: Multiple Boolean flags bar chart

jyothish8807 — Wed, 06 Jun 2018 04:43:45 GMT

Hi Camille,

Yes, it will not be displayed in current selection box because we are hard coding the cart to always show only the 'Y' values.

One way could be to add "Data" also in the dimension. Then when you click twice on the bar, you can see Y also as selected.

Br,