topic Expression in QlikView

Expression

dhanavindhan — Mon, 05 Mar 2018 07:40:23 GMT

Hi Experts,

I have a table of data. I wanted to write expression if my current month has no data means then i need to disaplay my previous month data in that place. I wrote expression like this,

if(isnull(month),-1) but it is not working.

I am new to both qlikview as well this expression thing pls help me.

Note: Only if the data is null it should get the previous month data not if data is there.

Thanks in advance

Regards,

Dhana R

Re: Expression

kevinalvino — Mon, 05 Mar 2018 07:53:27 GMT

Hi Dhana,

I think the one you should check for Null is not the Month , but The result of the expression.

if(IsNull(YourCalculationHere), (Insert Expression of The Previous Month, Your Month in this set Analysis should resulting Month-1), ( Insert YourCalculationHere ))

It should be roughly like that.

Best Regards,

Kevin

Re: Expression

YoussefBelloum — Mon, 05 Mar 2018 08:59:39 GMT

Hi,

can you attach a screen shot to the your table columns ?

Re: Expression

karthikoffi27se — Mon, 05 Mar 2018 09:28:48 GMT

Hi Dhana,

Try using the below expression

=If(IsNull(month),Addmonths(month,-1), month)

This should give you previous month value.

Many Thanks

Karthik

Re: Expression

bramkn — Mon, 05 Mar 2018 09:28:54 GMT

It is unclear how your data is structured. Month(max(Date)) will give you the maximum month available. If your calendar stops at the max date of data this might be helpful for you.

Edit made to make it work in jan as well