Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Suppressing zero for logarithmic scale

Hi all,

I have created a line graph, i need to use logarithmic scale, but some values contains zero, so log scale is not applying.

how to suppress the zero and log scale to made work.

I am using below expression:

count({<weekstart={">$(=date(max(weekstart)-35))<=$(=date(max(weekstart)-7))"}, DateType = {invitation}>}invitation_id)

Regards,

Pramod

Tags (1)
6 Replies
balrajahlawat
Esteemed Contributor

Re: Suppressing zero for logarithmic scale

can you post some sample data?

MVP
MVP

Re: Suppressing zero for logarithmic scale

Try to enabling 'Suppress zero values' on presentation tab.

Not applicable

Re: Suppressing zero for logarithmic scale

In the below discussion they have given the solution, but how can i use it for my expression?

Re: Logaritmic scale, values disapear?

Not applicable

Re: Suppressing zero for logarithmic scale

sorry, i can't find 'Suppress zero values' on presentation tab.

balrajahlawat
Esteemed Contributor

Re: Suppressing zero for logarithmic scale

I guess Qliksense does not have that

MVP
MVP

Re: Suppressing zero for logarithmic scale

On QlikSense, go to chart properties -- Add-On -- data processing. Disable Show NULL values.

Community Browser