topic Re: Show unique values and remove null values in straight table in QlikView

Show unique values and remove null values in straight table

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

Hi All,

I have to display tables with IDS that are marked X in primary table.

So when button 1 is clicked, table 1 displays IDS that are marked X in column "1. duplicate within team". So in above case - IDS 2,3,9.

But in my original application, in table1 I am getting lot of repeated IDS and null values. I want to show IDS once and also remove all blank rows in table1.

Let me know how to do this.

Regards,

Kinjal

stalwar1‌swuehl‌gwassenaar‌

Re: Show unique values and remove null values in straight table

sunny_talwar — Fri, 13 Jul 2018 15:22:17 GMT

So when button 1 is clicked

What is button 1 here? 'Duplicate within team' or 'redundant globally'? clicking on either of them does nothing for me or am I missing something?

Re: Show unique values and remove null values in straight table

kinjal1645 — Fri, 13 Jul 2018 15:27:39 GMT

'Duplicate within team' is button 1. When it is clicked it displays IDS that are marked X in column "1. duplicate within team". In this case, IDS 2,3,9.

Re: Show unique values and remove null values in straight table

sunny_talwar — Fri, 13 Jul 2018 15:30:22 GMT

When I selected 'duplicate within team'... I see this

Which seems to have nothing different from when 'redundant globally' button is selected

Are you sure you sent the correct file?

Re: Show unique values and remove null values in straight table

kinjal1645 — Fri, 13 Jul 2018 15:40:01 GMT

It is the correct one

For this scenario, it happens to have same IDS.

Consider below:

Re: Show unique values and remove null values in straight table

sunny_talwar — Fri, 13 Jul 2018 15:43:19 GMT

Okay, that makes sense ... but what exactly are we trying to fix here?

Re: Show unique values and remove null values in straight table

kinjal1645 — Fri, 13 Jul 2018 15:52:57 GMT

I want to find list of IDS that are are marked as X i.e IDS are that are redundant within team and globally. So I tried doing it through chart i.e. table 1 and 2.

In my original application, table 1 displays duplicate IDS and blank rows but I want to display them once.

I am not able to replicate the scenario here with this data.

Re: Show unique values and remove null values in straight table

sunny_talwar — Fri, 13 Jul 2018 16:05:05 GMT

May be just leave IDS in there and remove all other dimensions? and wrap your expression around with Sum(Aggr(...., dimensions))

Re: Show unique values and remove null values in straight table

kinjal1645 — Fri, 13 Jul 2018 21:54:32 GMT

Thank you