topic Re: Count and Set Analys in QlikView

Count and Set Analys

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I cannot get this Count working, what do I do wrong?

= Count({< KundNr = {"=Sum( {$<$(vSetRolling12)>} $(vNettoFörs) )> $(vOmsG)"}>}Distinct KundNr)

kindly

Håkan

Re: Count and Set Analys

tresB — Wed, 26 Oct 2016 09:47:32 GMT

Without knowing your variable definitions it would be hard to even guess. Could you post your qvw sample?

Re: Count and Set Analys

sunny_talwar — Wed, 26 Oct 2016 09:52:51 GMT

I agree with tresesco‌ but for starters may be try this:

=Count({< KundNr = {"=Sum( {$<$(vSetRolling12), $(vNettoFörs)>} $(vOmsG)"}>}Distinct KundNr)

Re: Count and Set Analys

nagarjuna_kotha — Wed, 26 Oct 2016 09:55:03 GMT

Can u please share the sample file that shows ur issue.

Re: Count and Set Analys

Anil_Babu_Samineni — Wed, 26 Oct 2016 10:07:04 GMT

I really Don't no, Why do you use the Sum

Count({< KundNr = {"$(=RangeSum('vSetRolling12','vNettoFörs','vOmsG')"}>}Distinct KundNr)

Re: Count and Set Analys

Wed, 26 Oct 2016 10:07:07 GMT

Hello again,

this is the error I get:

All the variables works by themselves, it´s when I try to compare with variable vOmsG it fails.

I tried Sunny T:s change but got the same error. I will try to create an example qvw.

kindly

Håkan

Re: Count and Set Analys

sunny_talwar — Wed, 26 Oct 2016 10:09:31 GMT

Do you happen to have double quotes within any of your three variables? I think it would be helpful if we can see how you define your three variables?

Re: Count and Set Analys

Wed, 26 Oct 2016 11:26:32 GMT

Hello,

here are my variables:

Re: Count and Set Analys

Anil_Babu_Samineni — Wed, 26 Oct 2016 11:30:24 GMT

For 1st Variable Remove PeriodID

Re: Count and Set Analys

sunny_talwar — Wed, 26 Oct 2016 11:31:35 GMT

Try changing this to single quotes

Re: Count and Set Analys

tresB — Wed, 26 Oct 2016 11:32:13 GMT

Try replacing double quotes with single quotes in the vSetRolling12 variable definition.

Re: Count and Set Analys

sunny_talwar — Wed, 26 Oct 2016 11:33:26 GMT

Anil -

Why would you ask the OP to remove a set analysis statement bro? This will drastically change the result of the expression. I advice against removing PeriodID

Re: Count and Set Analys

rubenmarin — Wed, 26 Oct 2016 11:49:00 GMT

Hi Hakan, I think you'll need to create a variable that retrieves the different PeriodID to apply so you can avoid the double quotes in vSetRolling12, in example, create a variable vRolling12PeriodID like this:

=Chr(39) & Concat(Distinct {<PeriodID={"Same_conditions_as_in_vSetRolling12"}>} PeriodID, Chr(39) & ',' & Chr(39)) & Chr(39)

Then you can change the condition in vSetRolling12 to:

PeriodID={$(vRolling12PeriodID)}....

// Wich will contain only single quotes. Note that the PeriodID retrieved will be the same for all rows in the chart

Not tested, maybe there is a typo.

Re: Count and Set Analys

Anil_Babu_Samineni — Wed, 26 Oct 2016 12:06:49 GMT

Sunny, I thought that is Simple Expression. I didn't notice those in depth. Anyhow thanks for your inputs