topic Re: Expression to check value from same dimension in QlikView

Expression to check value from same dimension

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

Hi guys,

I have a report with monthly data and I'm trying to check if a value for the same dimension has changed from the previous month.

For example, for the following "P", I have a chart with "YearMonth" in column ("202007" = Jul 2020, "202008" = Aug 2020) and in expression I've put another dimension ("TM") to have the value of "TM" for each YearMonth:

As you can see, for the first "P" the value does not change from Jul 2020 to Aug 2020 (was and remains E) but for the second there's a variation from E to G.

Is there a way to check if there is a variation like the one you can see in the second record? Something basic like "Yes" or "NO" would be perfect.

Thanks in advance,

Andrea

Re: Expression to check value from same dimension

dplr-rn — Thu, 27 Aug 2020 15:55:33 GMT

yes its posssible with set analysis or if statments.

please elaborate how you want to display it

Re: Expression to check value from same dimension

qv_bazz_10 — Fri, 28 Aug 2020 06:10:36 GMT

Hi Dilipranjith,

first of all, thanks for your reply.

It's the same, maybe would be easier with an if statement but, if possible, could you please show me both ways?

Thanks again,

Andrea

Re: Expression to check value from same dimension

qv_bazz_10 — Fri, 04 Sep 2020 10:55:23 GMT

Any help?

Thanks in advance,

Andrea

Re: Expression to check value from same dimension

Brett_Bleess — Tue, 08 Sep 2020 21:15:24 GMT

@dplr-rn Sorry about the notifications not working well at the moment, just wanted to let you know the poster did respond back to you, not sure the info provided is enough, but I will let you respond back on that.

Regards,
Brett

Re: Expression to check value from same dimension

Kushal_Chawda — Tue, 08 Sep 2020 22:10:56 GMT

@qv_bazz_10 You will have many months so how you are going check this condition?

Re: Expression to check value from same dimension

qv_bazz_10 — Mon, 14 Sep 2020 11:03:22 GMT

Hello @Kushal_Chawda ,

first of all I should check the YM (yearmonth, text field) to find any previous one, then I'd have to check the values to find out if there's a change, is there a way to do both tasks?

Thanks in advance,

Andrea