topic Re: suppress null is not working for calculated dimension in QlikView

suppress null is not working for calculated dimension

venkatbza — Tue, 08 May 2018 14:19:44 GMT

Hi Friends,

I have created calculated dimension in straight table and check the suppress null check box and it is working fine in QV desktop, but when i push into QV access point it is not working. Please help me if any thing i missed here

Below is my calculated dimension.

If(Len(date) >=1,null(), 'null')

Thanks,

Venakt

Re: suppress null is not working for calculated dimension

sunny_talwar — Tue, 08 May 2018 14:39:02 GMT

Do you have a different QlikView version on server box? That might cause it as some previous versions of QlikView had problem with calculated dimensions and suppressing null values.

Re: suppress null is not working for calculated dimension

venkatbza — Tue, 08 May 2018 14:44:04 GMT

Hi Sunny,

I am using same version in qlikview and server box both are November 2017 SR1

Re: suppress null is not working for calculated dimension

sunny_talwar — Tue, 08 May 2018 14:52:20 GMT

I am not entirely sure why this is not working the same way

Re: suppress null is not working for calculated dimension

Anil_Babu_Samineni — Tue, 08 May 2018 14:57:24 GMT

Can you try this and tell us which works or not?

If(Len(date) >=1,'NA', 'null')

Re: suppress null is not working for calculated dimension

venkatbza — Tue, 08 May 2018 15:37:33 GMT

Hi Anil,

As per my requirement i need to put hidden if any values are there in date field and need to show only null values in report that is the reason i write a expression like if(len(date)>=1, null(),'null'). as per you suggested expression i can not convert values in to nulls it can covet values into 'NA'.

Re: suppress null is not working for calculated dimension

Anil_Babu_Samineni — Tue, 08 May 2018 15:41:50 GMT

I even not sure about the behavior. But, Null() returns '-'. To achieve same this? if(len(date)>=1, '-','null')

Long ago - I've read about Null() which not working in Access point. If i get that will definitely share it with you.