topic Re: Bar chart help. in QlikView

Bar chart help.

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

I have the data as below Sample

ID Lend Borrow Spend

1 Yes No Yes

2 No Yes No

3 No Yes Yes

I need to create a stacked bar chart where each bar will represent the type of Expense and it will show the count of Yes and no in the stacked bar.

How can I do this ?

Thanks much.

migueldelval — Wed, 20 Apr 2016 16:38:49 GMT

Hi AnsH

Maybe you can use "count" at the expression definition (=count(Lend).

Good Luck

sunny_talwar — Wed, 20 Apr 2016 16:52:56 GMT

Try CrossTable load:

Table:

CrossTable(Type, Flag)

LOAD * Inline [

ID, Lend, Borrow, Spend

1, Yes, No, Yes

2, No, Yes, No

3, No, Yes, Yes

];

apthansh — Wed, 20 Apr 2016 17:32:44 GMT

Awesome Sunny. Thank you very much. Appreciate your time and help.