topic Re: Column to row in chart in QlikView

Column to row in chart

Anonymous — Thu, 26 May 2016 07:24:26 GMT

i have a table as below

date A B C

2/10/2016 c c n

3/10/2016 c c V

i need a chart to show the process of one date

date : 2/10/2016

A C Succ

B C Succ

C n Failed

how can i do this

pipuindia99 — Thu, 26 May 2016 08:29:53 GMT

You can drag and drop that particular column to top in chart table. Try it and it works

Kushal_Chawda — Thu, 26 May 2016 08:43:35 GMT

Create Pivot Table and try to drag and drop your dimension horizontally

Thu, 26 May 2016 08:46:09 GMT

jsut create a pivot table with date and filed as dimension and status as metric.

Then drag 2nd the row to column.

Anonymous — Thu, 26 May 2016 08:47:56 GMT

the Pivot Table works, will i be able to add the third column based on the second colum in the chart

qlikview979 — Thu, 26 May 2016 11:07:04 GMT

Hi Praveen,

Create Pivot table and drag your Dimension Horizontally.

please find the attached file.

Regards,

Mahesh