# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

## Re: Conditional IF

Hi Oscar,

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

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

Regards

6 Replies
New Contributor II

## Re: Conditional IF

Hi Oscar,

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

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

Regards

Highlighted
MVP

## 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

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.

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
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.

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