Class(Count(Distinct [From – To State Code]), 100)

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

How to write syntax for Bucketing ? How above Expression works ?

Re: Class(Count(Distinct [From – To State Code]), 100)

ahaahaaha — Fri, 17 Mar 2017 08:48:30 GMT

Hi,

If in general, without seeing the data. You have a field named [From-To State Code].

Count(Distinct[From-To State Code]) - counts number of unique (non-repeating) values in the field [From-To State Code].

Function Class returns a string with a range of 100.

For example,

1) if Count(Distinct[From-To State Code]) = 45, expression Class(Count(Distinct[From-To State Code]), 100) return a string '0<=x<100'

2) if Count(Distinct[From-To State Code]) = 156, expression Class(Count(Distinct[From-To State Code]), 100) return a string '100<=x<200'

3) if 100 to replace 400 and Count(Distinct[From-To State Code]) = 620, expression Class(Count(Distinct[From-To State Code]), 400) return a string '400<=x<800'

For more information about function Class(), see here class ‒ QlikView

Regards,

Andrey

Re: Class(Count(Distinct [From – To State Code]), 100)

dhavalvyas — Fri, 17 Mar 2017 16:21:15 GMT

Thank you so much

topic Class(Count(Distinct [From – To State Code]), 100) in QlikView

Class(Count(Distinct [From – To State Code]), 100)

Re: Class(Count(Distinct [From – To State Code]), 100)

Re: Class(Count(Distinct [From – To State Code]), 100)