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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nrj
Contributor
Contributor

Add additional data for only 1month within the table

Hello everyone,

 

how do you add extra numbers to the formula just to change data for one month and not disturb other values?

I have the count(leads) wrong for the month of Feb 2021.

I want to add +2000 to the existing count and also not alter other numbers.

For example, I tried formula with if statement:

count(if(year=2021 and month=Feb and lead='Funnel',lead))+2000

This gives me the right value for Feb2021  but the wrong values for other months.

Can someone give me a better solution for this?

 

Thanks a lot 

Best Regards,

Neeraja

 

 

Labels (2)
0 Replies