topic Re: Skip Blank or Null Values in Chart in QlikView

Skip Blank or Null Values in Chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi.

I need to make a chart showing me the % of each letter , however in my BD SQL Server I have records in Blank, so when graphic shows me a column without a title on the chart, and that I need not see, I need skip all blank record of my calculations.

Example:

I use de cake chart, in the Dimensions i have:

and in the expression a use:

Your help please.
Thank you.

Re: Skip Blank or Null Values in Chart

sunny_talwar — Fri, 13 May 2016 16:22:59 GMT

Try this as your calculated dimension:

If(Len(Trim(PREGUNTA615_12)) > 0, PREGUNTA615_12)

Re: Skip Blank or Null Values in Chart

krishnacbe — Fri, 13 May 2016 16:26:11 GMT

Hi,

Check the "Suppress When Value is Null" option in Dimension Tab for PREGUNT625 Dimension.

Re: Skip Blank or Null Values in Chart

Gysbert_Wassenaar — Fri, 13 May 2016 16:31:25 GMT

Then that blank value is probably a space or an empty string. You can try something like =Count({<Segmento={"=Len(Trim(Segmento))>0"}>}PREGUNTA612_12) to hide that value.

Re: Skip Blank or Null Values in Chart

Fri, 13 May 2016 16:44:14 GMT

It does not work , I remain exactly the same, only me ordered from oldest to youngest .

Re: Skip Blank or Null Values in Chart

Fri, 13 May 2016 16:44:51 GMT

I have that option enabled and it does not work .
Thank you

Re: Skip Blank or Null Values in Chart

Fri, 13 May 2016 16:52:11 GMT

is correct, the value I have in my BD is an empty string .

Try to apply your code in Expression But I did not work or I'm misapplying .

Thank you

Re: Skip Blank or Null Values in Chart

Gysbert_Wassenaar — Fri, 13 May 2016 17:50:52 GMT

Ah, I see what happened. I used the name of your expression label instead of the name of the dimension. Try

=Count({<PREGUNTA615_12={"=Len(Trim(PREGUNTA615_12))>0"}>}PREGUNTA615_12)

Re: Skip Blank or Null Values in Chart

sunny_talwar — Fri, 13 May 2016 18:16:04 GMT

Would you be able to share a sample to show the issue?

Re: Skip Blank or Null Values in Chart

Fri, 13 May 2016 20:14:47 GMT

thanks gwassenaar‌ I Apply Your Solution and run!