topic Re: Problem with If statement in QlikView

Problem with If statement

Wed, 30 Apr 2014 09:41:00 GMT

Hi guys! I'm a new QlikView user and I need to make that shows sales which were made during 2012 year. I want to make an if expression which have to be something like that: if (year=2012), then Sales else Null end. I tried this one if (year=2012, Sales, Null), but it says that Null is a bad field. Thank you in advance!

Re: Problem with If statement

sudeepkm — Wed, 30 Apr 2014 09:43:44 GMT

you may use set analysis

sum({<Year = {2012}>} Sales)

or you can make it dynamic:

sum({<Year = {"$(=max(Year))"} >}Sales)

Re: Problem with If statement

bbi_mba_76 — Wed, 30 Apr 2014 09:44:31 GMT

Hi,

it is possible to write

if (year=2012, Sales)

if (year=2012, Sales, Null() )

but I don't see any aggregation.. sum( if (year=2012, Sales ))

or using set analysis sum({<year={2012}>} Sales)

Re: Problem with If statement

its_anandrjs — Wed, 30 Apr 2014 09:46:17 GMT

Write like expression like

if(Year = 2012 , Sum(Sales),Null( ))

Re: Problem with If statement

SunilChauhan — Wed, 30 Apr 2014 09:46:42 GMT

sum(if(Year=2012,Sales)

and Year in dimension

it will automake - for year other than 2012

go to presentation-> missing symbol type null there

and null symbol_. type null there

Re: Problem with If statement

Wed, 30 Apr 2014 09:50:11 GMT

Try this

=if (year='2012', sum(Sales), 'Null')

hope it will help........

Re: Problem with If statement

Wed, 30 Apr 2014 10:22:38 GMT

Guys, you're awesome! Thank you for the quick answers!

Re: Problem with If statement

its_anandrjs — Wed, 30 Apr 2014 10:25:47 GMT

I am Glad thanks

Thanks & Regards