topic Re: Line chart with two dimensions in QlikView

Line chart with two dimensions

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

i would like to create a line chart with both date and month in X axis w.r trend to Balances

i am having the below data....

i want to show the Date wise balances and month wise balances also.. can any one help me to do this.

sunny_talwar — Thu, 05 May 2016 08:20:38 GMT

Do you have three dimensions or 2? From the image it seems you tried with three dimensions?

florentina_doga — Thu, 05 May 2016 08:38:35 GMT

see attach.

Thu, 05 May 2016 09:00:51 GMT

Hi sunny,

to understand i have posted the image.

i want the trend for both date and month on X axis.

Thu, 05 May 2016 09:07:01 GMT

hi Floren

Data and month are my dimensions, Balances is my expression.

sunny_talwar — Thu, 05 May 2016 09:10:32 GMT

Would you be able to share a sample of what you have?

Thu, 05 May 2016 09:30:55 GMT

Hi Sowmya,

Do you want something like this?

If yes,

PFA.

Regards,

Anjali Gupta

Thu, 05 May 2016 09:39:30 GMT

Thank you Anjali..

but i do not want like that..

first i want to show the Date wise Balance trend

down to that i want to show for whole month trend

Thu, 05 May 2016 09:55:03 GMT

Hi Sowmya,

If you want to show in the same chart then both the lines will overlap.

As there will be 4 records for January and february (as per the data given above)

If you want to show date trend and month trend in a single chart (but one at a time), you can create a cyclic group.

Regards,

Anjali Gupta