topic Re: Values on data point in QlikView

Values on data point

santhoo_san — Tue, 12 Mar 2013 07:59:27 GMT

Hi,

I have a line graph like below. I need to show the data point values only at the start of line, mid of line and at the end of line. Can anyone help please.

Regards,

Santhosh

Re: Values on data point

sushil353 — Tue, 12 Mar 2013 08:20:01 GMT

I dont think so it is possible.

The possible solution may be if u have something like : show data point for range 7000-7500 then 8000-8500 and so on... but still that need to test

Re: Values on data point

jagan — Tue, 12 Mar 2013 08:21:28 GMT

Hi Santosh,

Please find attached file for solution.

Regards,

Jagan.

Re: Values on data point

sushil353 — Tue, 12 Mar 2013 08:24:23 GMT

Great!!

i didnt know that.

Re: Values on data point

santhoo_san — Tue, 12 Mar 2013 08:46:26 GMT

Thanks for you reply Jagan.

I have dynamic values (week dates) in the dimension. Dimension values will change every month. Ex: for the current month I get week dates 4, 11, 18 and 25 as these days falls on Mondays, but same dates will not remain for next month Mondays.

In the given graph, I have used weekdate for a quarter. I need to show values for 1st week date of the 1st month, 1st week date of 2nd month and value for the latest week date of third month.

Regards,

Santhosh

Re: Values on data point

jagan — Tue, 12 Mar 2013 08:58:14 GMT

Hi Santosh,

In place of hardcoded values, calculate start and end values by using Min and Max() and replace them in the expression. In the same calculate Mid values.

Hope this helps you.

Regards,

Jagan.