topic Re: Expression in QlikView

Expression

upaliwije — Thu, 31 Aug 2017 06:21:32 GMT

Hi Friends

I have created a variable for the Risk Day which is as follows

vh1=(RISK_DAY>=1 and RISK_DAY<=14)

Now I want to apply this vh1 to expression which is follows

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY=$(v1h)>}Nos)

But this expression does not show the required results. Pls correct my expression

Re: Expression

tresB — Thu, 31 Aug 2017 06:25:42 GMT

Try changing variable definition like :

vh1= '{>=1 <=14}'

Re: Expression

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:28:23 GMT

Yesterday, I learn this from sunny

SET vh1 = '{>=1 <=14}'

Then, Use below

sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY=$(v1h)>}Nos)

Re: Expression

upaliwije — Thu, 31 Aug 2017 06:42:55 GMT

Hi Anil

What I did was like this

Then the Variable look like this

Still result show is 0

Pls advise whether what I have done is correct

Re: Expression

its_anandrjs — Thu, 31 Aug 2017 06:44:53 GMT

Why not try with this

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = { $( ">=1 <=14" ) } >}Nos)

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = { $( >=1 <=14 ) } >}Nos)

Re: Expression

upaliwije — Thu, 31 Aug 2017 06:45:29 GMT

Sorry further to that there is an error mark in the expression as well

Re: Expression

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:45:59 GMT

May be this?

SET vh1 = '{">=1 <=14"}'

Re: Expression

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:46:28 GMT

Don't worry about error , That is Bug only not yet resolved

Re: Expression

tresB — Thu, 31 Aug 2017 06:46:48 GMT

If you are using SET, try removing single quotes from outside and put inside like:

SET vh1 = {'>=1 <=14'} ;

Re: Expression

upaliwije — Thu, 31 Aug 2017 06:48:50 GMT

Still result shown is 0

Re: Expression

Anil_Babu_Samineni — Thu, 31 Aug 2017 06:51:16 GMT

I think this?

=sum({<POL_TYPE={'N'},RISK_YEAR = {$(=Max(RISK_YEAR)-1)},RISK_DAY = {">=1 <=14" } >}Nos) // Try to check Single Quotes too

Re: Expression

upaliwije — Thu, 31 Aug 2017 06:59:45 GMT

Hi Anil

Your expression too works as well