topic Re: How do I create an expression in QlikView

How do I create an expression

Anonymous — Tue, 13 Sep 2016 13:38:17 GMT

How do I create an expression when I want to compare total Inforce premium of June 2016 over July 2016? (I am a newbie and not in IT).

Re: How do I create an expression

miguelbraga — Tue, 13 Sep 2016 15:50:07 GMT

Do the selection in Year 2016 and Monht July and then add these two expressions:

Current Month:

=max(Month)

Previous Month:

=Month(

AddMonths(

Date(

makedate(Year, max(Month), 1)

)

,-1

)

Hope this helps you

Regards,

Re: How do I create an expression

sunny_talwar — Tue, 13 Sep 2016 16:02:51 GMT

For comparing inforce premium? I think OP might need this

Sum({<Date = {"$(='>=' & Date(MakeDate(2016, 6, 1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(MakeDate(2016, 6, 1)), 'DateFieldFormatHere'))"}>}[Inforce Premium])

Sum({<Date = {"$(='>=' & Date(MakeDate(2016, 7, 1), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(MakeDate(2016, 7, 1)), 'DateFieldFormatHere'))"}>}[Inforce Premium])

Re: How do I create an expression

krishnacbe — Tue, 13 Sep 2016 16:04:21 GMT

Hi,

Try with below expressions

Jun Month

=sum( {<Year={"2016"},Month={"Jun"}>}InsurancePremium)

July Month

=sum( {<Year={"2016"},Month={"Jul"}>}InsurancePremium)

If the month and year should be dynamic, then create a variable to calculate the same.

Re: How do I create an expression

miguelbraga — Tue, 13 Sep 2016 16:05:47 GMT

I didn't understood that... You're right and OP should consider your answer as the correct one

Regards,

Re: How do I create an expression

sunny_talwar — Tue, 13 Sep 2016 16:09:37 GMT

Well, I don't think we are still there. I think these are static expression and I think OP might be looking for something more dynamic. This, to me, looks like just a start