topic Re: Hi, please help with the set analysis expression? in QlikView

Hi, please help with the set analysis expression?

Vidit — Mon, 04 Jul 2016 15:11:30 GMT

I need to write an ecpression so that the previous Qtr is also visible with the selected.

PFA for more details.

Thanks in advance.

swuehl — Mon, 04 Jul 2016 17:08:23 GMT

Maybe use something like

=sum({$+1<Prod = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}Count)

[having PeriodNum created in the script to get an easier access to the previous period.]

Vidit — Tue, 05 Jul 2016 07:45:19 GMT

Hi,

Thanks for your reply, its very close to what I need.

do you think we can do something to hide the highlighted white space, in this solution.

swuehl — Tue, 05 Jul 2016 19:05:35 GMT

I think that's the default Qlik behaviour for two dimensions in group style mode.

One option would be to use a single dimension (e.g. by concatenating your current two into a single one)

Vidit — Wed, 13 Jul 2016 11:23:05 GMT

Hi,

What if another column Div is added to the table.

How to include that in

sum({$+1<Prod = {'D'},PeriodNum={$(=Max(PeriodNum)-1)}>}Count)

Please suggest