topic Re: How to hide negative value in linear trend line in QlikView

How to hide negative value in linear trend line

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

Hi,

I have a line chart and also I am using linear trend in the expression tab to showcase our trend over the selected period of time.

My question is there any mechanism or way to hide the negative value in the line chart for trend line, we want to stop it once it touches 0 value.

Please give me your thoughts.

Thank you,

Re: How to hide negative value in linear trend line

PrashantSangle — Fri, 17 Nov 2017 09:51:39 GMT

You can use if()

like if(sum(sales)>0,sum(Sales))

Regards,

Re: How to hide negative value in linear trend line

ashis — Fri, 17 Nov 2017 10:21:08 GMT

HI Prashant,

Thank you for your reply. It does not work for trend line.

Regards,

Re: How to hide negative value in linear trend line

sumanta12 — Fri, 17 Nov 2017 10:42:56 GMT

First make a calculated dimension like below:

=IF(sum(Sales)>0,'Your Dimension field')

check suppress value is null.

Then put your expression in the expression section.

Re: How to hide negative value in linear trend line

ashis — Fri, 17 Nov 2017 11:51:04 GMT

Hi,

I am using Date as dimension, and if I put

=if(sum(sales)>0,'Date') , and suppress null value , my chart is not able to get data. and I am getting error in calculating dimension.

Regards,

Ashis

Re: How to hide negative value in linear trend line

sumanta12 — Fri, 17 Nov 2017 11:53:48 GMT

Please Share Sample Data.

Re: How to hide negative value in linear trend line

sumanta12 — Fri, 17 Nov 2017 12:08:56 GMT

Put this in calculated dimension

=IF(AGGR(SUM(Sales),Date)>0,Date)

Re: How to hide negative value in linear trend line

ashis — Mon, 20 Nov 2017 09:50:27 GMT

Hi Sumanta,

As proposed , I have created calculated dimension as date, then check on the suppress when value is null option.

However I am still getting trend line value in negative .

Due to security purpose I am unable to share sample data.

I want trend line to stop when it touches zero.

I appreciate your response.

Re: How to hide negative value in linear trend line

jyothish8807 — Mon, 20 Nov 2017 11:07:30 GMT

Hi Ashish,

You cannot put conditions for a trend line. What you can do is create a expression instead of using the trend line option and you can set the style in line format. '<S1>' to '<S4>'.

Hope this helps.

Br,