topic Need expression in QlikView

Need expression

Mon, 09 Mar 2015 03:07:40 GMT

Hi all,

i have a data set like this for the current month i need to show the previous month actual values.and for the

remaining months it should be outlook values(i will get data from jan-dec for every month). !

PFA

Anonymous — Mon, 09 Mar 2015 04:42:08 GMT

Hi Sruti,

Can you be bit more clear on your requirement????

tresB — Mon, 09 Mar 2015 05:13:18 GMT

Like this?

If(month=Month(Today()),Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

PFA

Mon, 09 Mar 2015 07:52:23 GMT

Hi Tresesco,

In the If condition it will take only today month.but wat i need is from jan to today's month it should be actulas

and remaining all are outlook values

jagan — Mon, 09 Mar 2015 08:11:20 GMT

Hi,

Then try like this

If(month < Month(Today()),Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

OR if you have a date field then try like this

If(DateFieldName < Today(), Sum({<scenario={'actuals'}>}fin),Sum({<scenario={'outlook'}>}fin))

Hope this helps you.

Regards,

Jagan.

jagan — Mon, 09 Mar 2015 09:45:55 GMT

Hi,

I used < in condition, so it will return the values upto the current month. Or in script you can try like this

Data:

LOAD

'Actual' AS Data

FROM ActualData

WHERE Date < Today();

Concatenate(Data)

LOAD

'Outlook' AS Data

FROM OutlookData

WHERE Date >= Today();

Now in frontend there is no need of conditions at all, you can just use Sum(fin).

Hope this helps you.

Regards,

Jagan.