topic Re: Line chart with two dimensions at x-axis issue.... in QlikView

Line chart with two dimensions at x-axis issue....

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have an issue with line chart, as i am not able to plot two dimensions(Phase&approved date) at x-axis.

i have attached the sample data with mock up chart, Please try to resolve the issue.

Thanks in advance.

Re: Line chart with two dimensions at x-axis issue....

Gysbert_Wassenaar — Mon, 07 Nov 2016 17:06:29 GMT

What you want isn't possible in a single line chart. It cannot have two dimensions at the x-axis. You either need to combine the two dimensions into one. Or you can try text-in-chart objects (add those on the Presentation tab) or use Text objects and place them below the line chart.

Here's what it can look like if you use a calculated dimension:

Here's the expression for the calculated dimension:

=dual(

If([Date Apporoved]=aggr(nodistinct max(total <Phase> [Date Apporoved]),Phase)

OR [Date Apporoved]=aggr(nodistinct min(total <Phase> [Date Apporoved]) ,Phase),

Phase

,' |') & ' ' & [Date Apporoved]

,[Date Apporoved]

)

Re: Line chart with two dimensions at x-axis issue....

Anonymous — Tue, 08 Nov 2016 06:29:06 GMT

Thanks gysbert wassenaar..