Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

If Statement Short-circuiting ERROR !!

Hello There,

I am facing problem when i am writing a condition with if statement which is not giving me the right values .

The Syntax is given below:

sum(if(vReportDate=[Posting Date] and (Season <>vCurrentSeason or (Season='NA' and Department='COR')),Quantity*-1))

I have to make a if statement in which posting date is the date which is entered by the user and season of a particular item is not equal to current season and also when season is NA and department is COR, it should NOT be included and rest all the season and department be included.

Kindly Help. I am Stuck !

1 Reply
Highlighted
Not applicable

Re: If Statement Short-circuiting ERROR !!

sum( 

          if (  ($(vReportDate)=[Posting Date] and Season <>$(vCurrentSeason))

                 or

                 (Season='NA' and Department='COR')

                ,

                Quantity*-1

            )

       )