topic Re: logice in QlikView

logice

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Iam trying to use this in a dimesion .

Can please someoen guide me if this is wrong ...

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

vCurrYr =Year(Max(Created))

vPrevYr=Year(AddMonths( Max(Created),-12))

vPrevPrevYr=Year(AddMonths( Max(Created),-24))

In my dimesion i want to bring show 24 months data Like (jan-2015, Feb-2015......tll date )

to achieve this this iam trying to do the abive part ..

Thanks in advance

Re: logice

prma7799 — Tue, 31 Oct 2017 04:39:41 GMT

Please check variable vPrevPrevYr=Year(AddMonths( Max(Created),-24))

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

Re: logice

smilingjohn — Tue, 31 Oct 2017 07:56:15 GMT

Hi PAM

Is there something wrong in this ..

I mean what should I do ...What do I need to correct

Re: logice

mdmukramali — Tue, 31 Oct 2017 08:02:51 GMT

Hi,

it seems the error in the variable name.

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrePrevYr)),MonthName(Created))

vCurrYr =Year(Max(Created))

vPrevYr=Year(AddMonths( Max(Created),-12))

vPrevPrevYr=Year(AddMonths( Max(Created),-24))

Updated:

=If(match(Right(monthname(Created),4),$(vPrevYr),$(vPrevPrevYr)),MonthName(Created))

Thanks,

Mukram

Re: logice

smilingjohn — Tue, 31 Oct 2017 08:26:35 GMT

Hi mukhram

I changed th variable names accordingly

But the error is still seems to be the same ...

Can you ease give me an example of he same as a sample ...It will really great helpufull for me

Re: logice

mdmukramali — Tue, 31 Oct 2017 08:44:16 GMT

Hi John,

can you share your sample data and expected output so it will be helpful for us as well as You also.

Re: logice

techvarun — Tue, 31 Oct 2017 08:45:01 GMT

Do you have data in Created column for all the months?

Then Use =Month(Created) in dimension

and in the dimensions limit tab show only largest 24 Values

Re: logice

techvarun — Tue, 31 Oct 2017 09:07:07 GMT

Or use this formula in Dimention

=If(match(Right(monthname(Created),4),$(vPrevPrevYr),$(vPrevYr)),MonthName(Created))

Re: logice

smilingjohn — Tue, 31 Oct 2017 09:20:55 GMT

Hi,

Please find the attachment of the QVW file

Re: logice

mdmukramali — Tue, 31 Oct 2017 09:45:54 GMT

Hi,

find the attached file.