topic Re: creating secondary line chart in QlikView

creating secondary line chart

kumarkp412 — Mon, 16 Mar 2015 11:52:31 GMT

Hi Friends,

I am facing problem to creating the two dimensional line chart. i am having three fields (start date ,end date and id)

i want to calculate the two dimensional line chart based on two date (i.e to in one chart to show the start date as one line and end date as another line ) based on this date i want to calculate count of ids

so i am using two expression to get the count

when i am taking the two date Fields in dimension, it is taking one dimension and other dimension it is ignoring and i am getting the two line of same value .

Can any one help me.

Thanks in advance,

Re: creating secondary line chart

MK_QSL — Mon, 16 Mar 2015 13:10:52 GMT

Temp:

Load ID, StartDate, EndDate From TableName;

LinkTable:

Load ID, StartDate as Date, 'START' as Flag Resident Temp;

Load ID, EndDate as Date, 'END' as Flag Resident Temp;

Now create a Line Chart

Dimension

Date

Expression

COUNT({<Flag = {'START'}>}DISTINCT ID)

COUNT({<Flag = {'END'}>}DISTINCT ID)

Re: creating secondary line chart

buzzy996 — Mon, 16 Mar 2015 13:15:46 GMT

can u try this,

one "start date" dimension with y-axis1 ans end date with y-axis 2 by changing the POSITON(right to top) of dimension from Axes tab.

Re: creating secondary line chart

kumarkp412 — Mon, 16 Mar 2015 14:08:39 GMT

Hi Manish,

Thanks for reply,

I tried this what you send, but it was giving the different values,

Thanks

Kumar

Re: creating secondary line chart

kumarkp412 — Mon, 16 Mar 2015 14:16:23 GMT

Hi Shiva ,

I also tried the position (right to top) in axes tab ,but it is not giving the correct value.By using that it will divide the axes two axes.

Thanks

Kumar

Re: creating secondary line chart

MK_QSL — Mon, 16 Mar 2015 14:19:16 GMT

Provide Sample Data please

Re: creating secondary line chart

kumarkp412 — Mon, 16 Mar 2015 22:04:18 GMT

Hi Manish ,

I have made some little changes in the script you tried ,Then it is coming correctly

Thanks

Kuamr