topic Help needed on Line chart in QlikView

Help needed on Line chart

Mon, 12 Mar 2012 13:29:14 GMT

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
Share	X	Y	Z	A	B	C	D	E	F
Share1
Share2
Share3
Share4
Share5
Share6
Share7
Share8
Share9

Hey I want my line chart to be in the way that Share1 to 9 falls on X-axis and I have the option to select either X or Y or all(as many as i want). My X,Y,Z,A......F are my Drugs.

What I did:

I placed my share in dimension and in expression i added Only(X), Only(Y)......Only(F). Now i am getting the line chart but I am not able to select drugs on my choice. Kindly help me.................

Thanks in Advance

Regards

Sagar Gupta

Help needed on Line chart

pover — Mon, 12 Mar 2012 18:12:35 GMT

It would be easier if you can change your table to the following structure:

Share Drug Value

1 X 10

1 Y 7

2 X 8

Karl

Help needed on Line chart

Tue, 13 Mar 2012 05:02:30 GMT

Thanks Karl,

I also did the same

🙂

Sagar

Help needed on Line chart

Tue, 13 Mar 2012 05:51:07 GMT

Hey Karl,

Its working and I would like to know if there is any other way to do it.

Sagar

Help needed on Line chart

pover — Thu, 15 Mar 2012 00:28:52 GMT

Hi Sagar,

No. You either create an expression for every Header or you do a crosstable function to rotate the columns into rows and leave it in the format that I posted above. I prefer the second option.

Karl