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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Labels (1)
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?