topic Re: Simple If condition not working at script level in QlikView

Simple If condition not working at script level

senarath — Mon, 19 Jan 2015 05:20:53 GMT

Hi,

I'm trying to gross up with tax rate as below at script load. However, the rate that get applied is first rate that I have given which is 1.2571 and else condition rate of 1.2459 does not get calculated.

I get 1.2571 for the total period.

If([Business Date]<='12/31/2014',([Pkg Revenue]*1.2571),([Pkg Revenue]*1.2459)) as [Pkg Revenue]

I'm having 11.2 SR7 in the server. Any Idea....?

Thanks

Senarath

Re: Simple If condition not working at script level

jonathandienst — Mon, 19 Jan 2015 05:25:54 GMT

Then the if condition is always satisfied. Do you have any dates after Dec 31? If so, then check your date formatting, as either [Business Date] or '12/31/2014' are not being interpreted correctly as a date.

HTH

Jonathan

Re: Simple If condition not working at script level

Anonymous — Mon, 19 Jan 2015 05:29:59 GMT

Hi,

Try formatting date in Date#('12/31/2014', 'MM/DD/YYYY') in the condition instead of directing using it.

Re: Simple If condition not working at script level

Anonymous — Mon, 19 Jan 2015 05:30:48 GMT

Hello,

try using date(date#([your date],'MM/DD/YYYY')).

HTH

Re: Simple If condition not working at script level

avinashelite — Mon, 19 Jan 2015 05:34:57 GMT

Hi Senarath,

Please check whether dates after the 12/31/2014 is so then only the condition will get satisfied.

As Jonathan said check for the date format and covert both the date to same format like:

Date([Business Date],'MM/DD/YYYY')<='12/31/2014 this should work. If not please post your app with sample data

Re: Simple If condition not working at script level

senarath — Mon, 19 Jan 2015 05:59:48 GMT

Hi,

I applied date format also and did NOT work

If(Date#([Business Date],'MM/DD/YYYY')<='12/31/2014',([Pkg Revenue]*1.2571),if(Date#([Business Date],'MM/DD/YYYY')>='01/01/2015',([Pkg Revenue]*1.2459))) as [Pkg Revenue],

FIRST Rate get applied to all the period and not the second.

Pls find attached the excel data file FYI...!!!

Thanx

Re: Simple If condition not working at script level

avinashelite — Mon, 19 Jan 2015 06:09:36 GMT

Hi,

Please find the attachment for the solution .

The Expression is

If(Date([Business Date],'MM/DD/YYYY')<='12/31/2014',([Pkg Revenue]*1.2571),if(Date([Business Date],'MM/DD/YYYY')>='01/01/2015',([Pkg Revenue]*1.2459))) as [New Pkg Revenue]

Re: Simple If condition not working at script level

jagan — Mon, 19 Jan 2015 06:28:23 GMT

Hi,

Try like this

Date#() will give you the date in numeric format.

If(Date([Business Date],'MM/DD/YYYY')<='12/31/2014',([Pkg Revenue]*1.2571),if(Date([Business Date],'MM/DD/YYYY')>='01/01/2015',([Pkg Revenue]*1.2459))) as [Pkg Revenue],

If(Date([Business Date],'MM/DD/YYYY')<=MakeDate(2014, 12, 31),([Pkg Revenue]*1.2571),if(Date([Business Date],'MM/DD/YYYY')>=MakeDate(2015, 1,1),([Pkg Revenue]*1.2459))) as [Pkg Revenue],

Hope this help you.

Regards,

Jagan.

Re: Simple If condition not working at script level

senarath — Mon, 19 Jan 2015 07:07:54 GMT

Hi All,

I found the issue. All the replies that you guys had posted apply correctly. However, I just verified that environmental variables in Main page is as default as I had customized date format as DD/MM/YYYY.

When I changed that to default, problem was solved.

Many thanks you guys.

Senarath