Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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
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.
Oscar,
Are you brazilian? If yes, you can add me in Skype, then we can help each other.
Cheers
I'm from Colombia but I dont falo português
Anyway, will be very helpul have u in Skype if you dont mind.
It'll be a great pleasure. Find me there:
Skype: justen.thiago