topic Re: Comparative analysis with Alternate States in QlikView

Comparative analysis with Alternate States

Wed, 01 Jul 2015 13:10:54 GMT

Hi everybody. It's the first time i wrote here.

I read many discussions but i didn't find the solutions.

I have this problem.

I have two different states (A and B) with selected years (2014, 2015).

The expressions to calculate active customers of a selected shop (nomeNegozio) in different years (2014 and 2015) are:

Count ({statoA<KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

Count ({statoB<KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

Now i would like to calculate customers that were active in 2014 but not in 2015. I tried many expressions but nothingI

Count({statoB-statoA <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

Count({statoA <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>-statoB <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

Anyone could help me please?

Thank you

Re: Comparative analysis with Alternate States

ramoncova06 — Wed, 01 Jul 2015 16:38:26 GMT

do you define the year ? by the selection ?

if that is true then try with this

Count ({statoA<KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio, KidCustomer =e ({statoB})>} DISTINCT KidCustomer)

Re: Comparative analysis with Alternate States

Thu, 02 Jul 2015 14:01:47 GMT

Perfetct!! Thankyou.

I don't really understand the syntax but it runs...

Re: Comparative analysis with Alternate States

ramoncova06 — Thu, 02 Jul 2015 14:40:49 GMT

glad it worked, since you states worked based on selections the KidCustomer =e ({statoB}) is telling it to exclude every possible value that is part of the selection in startoB