Conditional IF

[oscargm_bi]

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,

[alejandrow · Accepted solution]

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]

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

[oscargm_bi]

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