topic Re: Year to month Stutus Update issue in QlikView

Year to month Stutus Update issue

Anonymous — Mon, 20 Apr 2015 05:46:27 GMT

Hi,

I have fields like CustID ,year , month and status .status field contains every year status update of CustId if I click on CustID the status of that custuid will be displayed with currentYear .If any custID has no satus in this year(means only 2015) it will display last year status(ie 2014) ,in prev year also no status update for that custID it will display 'NO Status'.in every year status will be updated on June month .Can any one please help me how to write a expression for this.

Thanks in Advance.

Re: Year to month Stutus Update issue

jagan — Mon, 20 Apr 2015 05:57:56 GMT

Try this expression

=Alt(Only({<Year={$(=Year(Today()))}>} Status), Only({<Year={$(=Year(YearStart(Today(), -1)))}>} Status), 'No Status')

Hope this helps you.

Regards,

Jagan.

Re: Year to month Stutus Update issue

Anonymous — Mon, 20 Apr 2015 06:11:29 GMT

Thankyou jagan,

But every year june status will be updated so we have to write condition for that.

Re: Year to month Stutus Update issue

jagan — Mon, 20 Apr 2015 06:15:19 GMT

Hi,

Can you attach sample data and your expected output? It would be easier to understand and give solution easily.

Regards,

Jagan.

Re: Year to month Stutus Update issue

jagan — Mon, 20 Apr 2015 06:17:55 GMT

Hi,

Create a variable like below

vCurrentStatusYear = If(Today() >= MakeDate(Year(Today()), 6), Year(Today()), Year(Today()) - 1)

=Alt(Only({<Year={$(=vCurrentStatusYear)}>} Status), 'No Status')

Hope this helps you.

Regards,

Jagan.