Subfield doing a distinct automatically

diwaskarki — Wed, 15 Aug 2018 21:30:48 GMT

Hello Guys,

I think when I use subfield on a string, it automatically does a distinct.

For example in my database i have a user Tim. So lets say Tim is the key and the value for tim is stored in a field called 'Role'.

Data stored in 'Role' for the key 'Tim' looks like this:

Key Role Date

Tim B2E Role, B2C role, B2D Role, 102124541

Tim B2E Role, Selfmade Role, Tims Role 5432112132

Tim Selfmade Role, Tims Role, handy role 4512145421

I am doing a subfield on role like this : Subfield(Role, ',') As [Separated Role]. So now role stores data like this

B2E Role

B2C Role

B2D Role

Selfmade Role

Tims Role

handy role.

I have a listbox that display Tim and another table that display Role. When I click on Tim , I want to see:

B2E Role

B2C Role

B2D Role

B2E Role

Selfmade Role

Tims Role

Selfmade Role

Tims Role

handy role

But i do not see the duplicate values. Is there a workaround to this?

Re: Subfield doing a distinct automatically

rwunderlich — Wed, 15 Aug 2018 22:24:37 GMT

A table will display one row for each unique combination of dimension values. If you are only displaying [Separated Role], you would only see each value once. You will need to include another dimension such as Date.

-Rob

Re: Subfield doing a distinct automatically

diwaskarki — Thu, 16 Aug 2018 02:04:45 GMT

Thank you so much Rob

topic Re: Subfield doing a distinct automatically in QlikView

Subfield doing a distinct automatically

Re: Subfield doing a distinct automatically

Re: Subfield doing a distinct automatically