topic Re: Calculation error in QlikView

Calculation error

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

HI all

All i want is if the Member is State and outifstate multiply by [2018 Guests]. i am getting some error.

if( [Member] ='State','outofstate', * Num([2018 Guests])

Re: Calculation error

lockematthewp — Tue, 08 Oct 2019 16:30:32 GMT

in the else part of your if statement, you must define what is to be multiplied. like:

if( [Member] ='State','outofstate', VALUE * Num([2018 Guests]))

or if you just want the number of 2018 guests,

if( [Member] ='State','outofstate', Num([2018 Guests]))

Also I noticed you are missing a close parenthesis at the end.

Re: Calculation error

Brett_Bleess — Mon, 14 Oct 2019 17:26:21 GMT

Did Matthew's post get you what you needed or are you still trying to sort things out? If his post did work, please be sure to use the Accept as Solution button on his post to mark it and give him credit for the help. If you did something different, consider posting for others and then mark that, and if you are still working on things, leave an update.

Regards,
Brett