topic Re: Dimension Value on Data Point of the Line Chart in QlikView

Dimension Value on Data Point of the Line Chart

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

Hi,

I have a Line chart which is a daily trend. I am displaying the Data values only on those data points where date = Month End Date.

Now, the challenge is I need to show the DATE as well on the Data Point. I have tried by creating a new Expression and then showing it as a Data Value, but it works only if I have 1 Line in the graph, but I have multiple expressions and multiple lines on the graph.

Please suggest if any method to do this.

I have attached the expected result.

Thanks

Re: Dimension Value on Data Point of the Line Chart

kkkumar82 — Tue, 02 May 2017 09:32:57 GMT

In Qliksense this is not possible , the regular dual function doesn't work

Re: Dimension Value on Data Point of the Line Chart

prachisangewar — Tue, 02 May 2017 09:43:02 GMT

Hi,

Sorry tagged wrongly to Sense. This requirement is for QlikView.

Changed the tagging now.

Re: Dimension Value on Data Point of the Line Chart

kkkumar82 — Tue, 02 May 2017 09:46:17 GMT

Then it is possible,

Some thing like this

Re: Dimension Value on Data Point of the Line Chart

kkkumar82 — Tue, 02 May 2017 09:47:50 GMT

I dont have date dimension in the sample data, if you have date

then use your expression as

Dual(Sum(Sales)&'('&DateDimension&')', Sum(Sales))