How to make Bar chart when I have data like this?

[panwipa2528]

  This is the Data

Member ID	Type	Travel	Shopping	Sleep
001	A	x
002	B		x	x
003	C	x	x
004	C	x	x	x
005	B	x
006	B			x

I want to do the bar chart like this

[Anil_Babu_Samineni]

first do the cross table and then create bar chart with dimension as Fieldname of Cross and then Type

Finally, Create expression as you need

[vardhancse]

Hi,

Yes you can convert rows to columns and columns to rows.

Using Crosstable function in QV.

[Kushal_Chawda]

Crosstable(Data,Member,2)

LOAD MemberID,

         Type,

         Travel,

         Shopping,

         Sleep

FROM Table

[panwipa2528]

How to cross table i already cross but the bar chart as the same

[panwipa2528]

I want the same function as switch row/column. pleaseeeeee.

[Anil_Babu_Samineni]

Try to promote dimension to x-axis, Because i don't have qlikview software with me. If not, Follow the syntax from Kushal.

[panwipa2528]

stalwar1‌

[sujeetsingh · Accepted solution]

Her is away to achive it .

[antoniotiman]

Hi,

see Attachment.

Regards,

Antonio