Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis with Missing Values

Hi,

i have this situation :

      

CD_CODEPrezzo2014Prezzo 2015Qty 2015Prezzo x Qty 2015Coverage
S0440871-13,64-12-164-€ 164
S0302446-8,76761€ 35

When Prezzo2014 is equal to '-' , I want that Coverage is equal to zero.

How can i do?

I tried with Isnull Function or Len function but doesn't work.

Thanks a lot

10 Replies
Not applicable
Author

I tried with your expression but there is a problem. I have a drill down group in my linear table and when click on the row to drill total result change.  What is it the problem?