topic Re: How to make Bar chart when I have data like this? in QlikView

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

panwipa2528 — Thu, 29 Jun 2017 02:30:12 GMT

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 — Thu, 29 Jun 2017 03:14:25 GMT

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 — Thu, 29 Jun 2017 03:31:59 GMT

Hi,

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

Using Crosstable function in QV.

Kushal_Chawda — Thu, 29 Jun 2017 04:54:01 GMT

Crosstable(Data,Member,2)

LOAD MemberID,

Type,

Travel,

Shopping,

Sleep

FROM Table

panwipa2528 — Thu, 29 Jun 2017 04:55:12 GMT

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

panwipa2528 — Thu, 29 Jun 2017 04:56:39 GMT

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

Anil_Babu_Samineni — Thu, 29 Jun 2017 05:02:12 GMT

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

panwipa2528 — Thu, 29 Jun 2017 05:08:32 GMT

sujeetsingh — Thu, 29 Jun 2017 05:14:47 GMT

Her is away to achive it .

antoniotiman — Thu, 29 Jun 2017 06:00:44 GMT

Hi,

see Attachment.

Regards,

Antonio

sujeetsingh — Thu, 29 Jun 2017 12:47:55 GMT

Seems it worked for you. .