Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Theo_Westseit
Contributor III
Contributor III

Lines without values ​​are hidden

Hello Guys,

I am currently struggling with the following frontend problem:

I created a new App with tables, but Lines without values ​​are hidden, although i activated the "Show zero values" (Chart Property / Add-Ons). So if i change the Selection the structure of tables varies, although it (the lines) should be fixed. 

What options are left to show 0 if there is no value?

Thanks!!

 

Labels (1)
4 Replies
MEDHA07
Contributor III
Contributor III

In backend script itself create new filed with if conditional statements wherever it has null or blanks result should be zero .

if(isnull(field) or field=' ' or field='-' ,0,field) as Dervflag

field -Measure field

Rohan
Specialist
Specialist

Hi,

Try this in the Measure expression :

If(isnull(Measure), 0, Measure)

Theo_Westseit
Contributor III
Contributor III
Author

Hello Guys, thanks for your answers. Do you think there is a possibility to implement the code into frontend? I've tried If(isnull(Measure), 0, Measure) at frontend but it didn't work...

Rohan
Specialist
Specialist

Hi,

Have you tried sum({1<set>}Measure) ?