topic Re: Show not distinct value in Objects in QlikView

Show not distinct value in Objects

Fri, 20 Jun 2014 06:08:57 GMT

Hello everyone,

I want to show the not distinct values in objects.

For example,

Load * inline

[

Duplicate_Data

];

While the list box shows only distinct value 1 for once. I think It make sense from the view point of business, since we make selections on it, which makes automatic grouping to be reasonable. But from the view point of data, it's weird because QlikView transforms my data without my permission!

I'm really confused about this point, and can any one help me?

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks all guys' help, and I was thinking to do group by hand. QlikView already treat data the right way.

Re: Show not distinct value in Objects

tresB — Fri, 20 Jun 2014 06:22:32 GMT

Try like:

Load Dual(Duplicate_Data, rowno()) as Duplicate_Data inline

[

Duplicate_Data

];

Re: Show not distinct value in Objects

jonathandienst — Fri, 20 Jun 2014 06:29:34 GMT

QV has not transformed your data - there are still three rows, but QV only displays the value once as there is no way of distinguishing the rows. QV is not a normalised database, so it allows duplicate rows.

To see this, create a straight table with Duplicate_Data as the dimension and Sum(Duplicate_Data) as the expression.

Tresesco's suggestion is one way to make the values distinct.

HTH

Jonathan

Re: Show not distinct value in Objects

Fri, 20 Jun 2014 06:38:16 GMT

It's smart, using the association which can achieve what I want. But I'm thinking if my question is absurd.

Re: Show not distinct value in Objects

Anonymous — Fri, 20 Jun 2014 06:40:27 GMT

Try below,

Load

Dual(Duplicate_Data, RowNo()) as Duplicate_Data

Inline

[

Duplicate_Data

];

Re: Show not distinct value in Objects

tresB — Fri, 20 Jun 2014 06:44:14 GMT

Your question is not absurd. But this is how qv works. And why qv would do so, because that is the way most of the business would like it to be.

Re: Show not distinct value in Objects

Fri, 20 Jun 2014 06:47:58 GMT

Thanks Jonathan, you already make it clear. Dimensions categorizes data, they're labels and it should definitely group data. I was thinking I should do the grouping by myself...