Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

oscargm_bi
New Contributor II

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
New Contributor II

Re: Conditional IF

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

6 Replies
alejandrow
New Contributor II

Re: Conditional IF

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

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
New Contributor II

Re: Conditional IF

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
Valued Contributor III

Re: Conditional IF

Oscar,

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

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
oscargm_bi
New Contributor II

Re: Conditional IF

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
Valued Contributor III

Re: Conditional IF

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

Skype: justen.thiago

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