Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joannaa93
New Contributor

Limiting the values on a line chart

Hi All,

I have the following problem with line chart created in QlikSense (see the picture and the description below).

The graph represents count of customer requests for each quarter and the expression on the X-axis is an IF function: if(quarterend(Date<Today(),YearQuarter). Therefore, I would expect the values on the X-axis to display data until 2017 Q4 as this is the last full quarter that has been completed. However, there is a grey line after that point that shows the count of requests for the first month of 2018 which should not be there.

Can anyone advise how to fix it? I tried different options but could not eliminate the problem. I think this is a QlikSense-specific problem as the same graph works perfectly fine in QV.

Thanks a lot in advance!

line chart.png

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Limiting the values on a line chart

Under your dimension: uncheck show null values

4 Replies
zebhashmi
Valued Contributor

Re: Limiting the values on a line chart

looks like you are using if function on the measure

try to put Null in Else space.

omarbensalem
Esteemed Contributor

Re: Limiting the values on a line chart

Under your dimension: uncheck show null values

joannaa93
New Contributor

Re: Limiting the values on a line chart

Hi Omar,

that indeed made the trick I used this option before and the graph didn't update for some reason, I gave it another shot yesterday though and now the grey line is gone. Thank you for your time and advice

omarbensalem
Esteemed Contributor

Re: Limiting the values on a line chart

good to know !

Then, if ur question has been asnwered, please make sure to close the thread by marking the correct answer as correct