topic Re: Count Distinct 2 fields in script? in QlikView

Count Distinct 2 fields in script?

Mon, 03 Jun 2013 14:43:55 GMT

Hi everyone,

I have a bar graph dimension:

FieldA

And I have a bar graph expression:

Count(DISTINCT FieldB & FieldC)

It works perfectly, however, I don't want FieldC to be available to everyone (I would like to drop it in the script). However, I still need to be able to pivot on dimension A. Is there any way to get just the count of distinct B & C for each A in the script, and then drop C?

Thank you

Re: Count Distinct 2 fields in script?

alexandros17 — Mon, 03 Jun 2013 14:47:19 GMT

Add a new field in the script

load

...

fieldA & FieldB as myField

...

From ...

Then you can delete FieldB and use myField in the expression

Re: Count Distinct 2 fields in script?

Mon, 03 Jun 2013 14:55:29 GMT

FieldB in my case is a user identification number, which I want to hide, so concatenating it to myField would still allow others to see and even sort it easily using Right().

I'm hoping to eliminate it entirely. Scrambling it somehow may work, but I think there's a way to model it away - just struggling to find a way.

Re: Count Distinct 2 fields in script?

alexandros17 — Mon, 03 Jun 2013 14:58:34 GMT

I think that if you need that value in a chart you have to keep it somehow ...

Use the function autonumberhash(FieldA,FieldB) as myField, no one will evesìr suspect that the code created will contain a user id ...

Re: Count Distinct 2 fields in script?

Mon, 03 Jun 2013 15:05:09 GMT

Ahh autonumber did it, thank you. I was thinking it would scramble A, scramble B, and then concatenate them together, but it instead concatenates then scrambles, which is what I need.

Thank you!