topic Compare same variable in two alternate states in QlikView

Compare same variable in two alternate states

Mr_small_t — Sat, 16 Nov 2024 01:20:59 GMT

I have two alternate states: "OG_20172018+0" and the following year "OG_20172018+1". In a chart/pivot table, which is set to be in the alternate state "OG_20172018+1", I have the following expression:

=(count({<
Rnr = P({"OG_20172018+0"<Lvl = {1}>}),
Group -= {"I", "U", "X"},
Lvl-= {">1"}
>}
DISTINCT if((Standardfilter = 1 or Standardfilter_2prioritet =1),
Rnr)))

Where Rnr is an reference number for each person, Lvl is a numeric variable indication which level each person are at, Group indicates which group the person are in, and Standardfilter and Standardfilter_2prioritet is [0,1]-indicators.

So far, so good. I get a list of 215 uniqe Rnr's. These Rnr's are in both states and they have the features in the expression.

Then i have another variable "Category" which is a text variable. For each of the 215 Rnr's i want to check if the Category-variable are identical in both states , and I want count these Rnr's.

I have tried to find post in the community to help me, but I am still stuck! Please, can anybody help me?

Regards,

Torbjørn

Re: Compare same variable in two alternate states

sunny_talwar — Thu, 06 Feb 2020 13:57:35 GMT

May be this

=(count({< Rnr = P({"OG_20172018+0"<Lvl = {1}>}) * {"=Only({"OG_20172018+0"} Category) = Only({"OG_20172018+1"} Category)"}, Group -= {"I", "U", "X"}, Lvl-= {">1"} >} DISTINCT if((Standardfilter = 1 or Standardfilter_2prioritet =1), Rnr)))

Re: Compare same variable in two alternate states

Mr_small_t — Fri, 07 Feb 2020 06:52:21 GMT

Hi Sunny

thanks for your reply! I see what you are trying. But it did not work ("Errors in expression") and I have not been able to "adjust" it to make it run. And suggestions?

Regards

Torbjørn

Re: Compare same variable in two alternate states

sunny_talwar — Fri, 07 Feb 2020 14:04:26 GMT

My bad, try this instead

=(count({< Rnr = P({"OG_20172018+0"<Lvl = {1}>}) * {"=Only({[OG_20172018+0]} Category) = Only({[OG_20172018+1]} Category)"}, Group -= {"I", "U", "X"}, Lvl-= {">1"} >} DISTINCT if((Standardfilter = 1 or Standardfilter_2prioritet =1), Rnr)))

Changed the double quotes around the state name to []. The reason is that we already have a "" used in the set.....

Re: Compare same variable in two alternate states

Mr_small_t — Wed, 12 Feb 2020 07:49:40 GMT

That one works brilliant! Thank you!