Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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?