topic Re: Different value for any group in QlikView

Different value for any group

Anonymous — Mon, 01 Feb 2016 08:09:58 GMT

Hello,

if i have PIPPO contain :

value 111111 5 times

value 22222 4 times

value 333333 7 times

value 44444 12 times

In expression section add :

count(distinct SubStringCount (VAR, 111111))

count(distinct SubStringCount (VAR, 22222))

count(distinct SubStringCount (VAR, 333333))

count(distinct SubStringCount (VAR, 444444))

the chart i obtain i have just one same (and only one) value and i need a value for any count.

Thanks

Mario Brozi

Chanty4u — Mon, 01 Feb 2016 09:31:11 GMT

count(Distinct urfield)

sunny_talwar — Mon, 01 Feb 2016 11:05:30 GMT

Not sure I completely understand what you are trying to do? Can you elaborate or provide a sample?

Anonymous — Mon, 01 Feb 2016 11:07:51 GMT

may be remove distinct from expression?

Still not clear, how data you are having in fields, could you post a sample?

Anonymous — Mon, 01 Feb 2016 11:09:45 GMT

If you have PIPPO then why you are using VAR?

Anonymous — Mon, 01 Feb 2016 11:14:09 GMT

Sorry PIPPO = VAR

Anonymous — Mon, 01 Feb 2016 11:37:09 GMT

How you can see the value blue and red in the graph are the same but they aren't.
If i use DISTINCT the value (green) isn't showed.

sunny_talwar — Mon, 01 Feb 2016 11:50:33 GMT

What do you get if you just use the expression without Count?

SubStringCount(PIPPO, 111111)

SubStringCount(PIPPO, 222222)

SubStringCount(PIPPO, 333333)

Anonymous — Mon, 01 Feb 2016 11:57:22 GMT

if i just use the expression without Count

SubStringCount(PIPPO, 111111)

SubStringCount(PIPPO, 222222)

SubStringCount(PIPPO, 333333)

i get Nothing, all blank.