Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
oscargm_bi
Contributor III
Contributor III

Conditional IF

Hello,

I am new to the Qlik world. What am I doing wrong?

= if ([ACCUMULATED SALES $ .VERIFICATION] = 'CANCELED', sum [ACCUMULATED SALES $ .VERIFICATION], '')

I want that in the SALES ACCUMULATED $ .VERIFICATION field add me if it says CANCELED, otherwise do not do anything.

What am I doing wrong?

Thank you,

1 Solution

Accepted Solutions
alejandrow
Contributor II
Contributor II

Hi Oscar,

You need to put the aggregation (SUM) before the IF.

Applied to your case:

= sum(if ([ACCUMULATED SALES $ .VERIFICATION] = 'CANCELED',  [ACCUMULATED SALES $ .VERIFICATION]))

Regards

View solution in original post

6 Replies
alejandrow
Contributor II
Contributor II

Hi Oscar,

You need to put the aggregation (SUM) before the IF.

Applied to your case:

= sum(if ([ACCUMULATED SALES $ .VERIFICATION] = 'CANCELED',  [ACCUMULATED SALES $ .VERIFICATION]))

Regards

Nicole-Smith

sum({<[ACCUMULATED SALES $ .VERIFICATION] = {'CANCELED'}>} [ACCUMULATED SALES $ .VERIFICATION])


You may want to check out some basic QlikView training.  You can find a lot online, but here is something to get you started: New to QlikView Videos

Also, if you are asking a question, you shouldn't mark it as "Assumed Answered".  You can see some information about the community and discussion threads here: Getting Started: Questions and Discussion Threads

oscargm_bi
Contributor III
Contributor III
Author

oh men, thank you so much.!!!! U help me a lot.

I know its a very dumb question, but Im learning. I dont have anybody to ask.

regards.

Thiago_Justen_

Oscar,

Are you brazilian? If yes, you can add me in Skype, then we can help each other.

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
oscargm_bi
Contributor III
Contributor III
Author

I'm from Colombia but I dont falo português

Anyway, will be very helpul have u in Skype if you dont mind.

Thiago_Justen_

It'll be a great pleasure. Find me there:

Skype: justen.thiago

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago