topic Re: Conditional IF in QlikView

Conditional IF

oscargm_bi — Thu, 22 Feb 2018 19:52:35 GMT

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,

Re: Conditional IF

alejandrow — Thu, 22 Feb 2018 20:18:44 GMT

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

Re: Conditional IF

Nicole-Smith — Thu, 22 Feb 2018 20:34:03 GMT

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

Re: Conditional IF

oscargm_bi — Thu, 22 Feb 2018 21:35:03 GMT

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.

Re: Conditional IF

Thiago_Justen_ — Thu, 22 Feb 2018 22:59:45 GMT

Oscar,

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

Cheers

Re: Conditional IF

oscargm_bi — Fri, 23 Feb 2018 13:07:40 GMT

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

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

Re: Conditional IF

Thiago_Justen_ — Fri, 23 Feb 2018 17:46:51 GMT

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

Skype: justen.thiago