How to show distinct value

[posywang]

Hi,

We had a data glitch from source file so it created two resource names with same values for other columns. It was not the first time the source system did that and we had no control over it so that's why I didn't go with the approach to just manually remove the wrong resource name, in case such issue happens again in the future. I am wondering if I can use set analysis or something to avoid data duplication in Qlikview. Attached is a simple sample file. Is it possible to show Headcount just once? I don't care which resource name shows up as long as there's only one row in table...

Current View:

Preferred View:

Thank you in advance. Any idea is appreciated!

[posywang]

New example is provided below. Please take a look and let me know if there's any further question. Thank you!

[tamilarasu · Accepted solution]

Yes Xia. Makes sense and I understood the issue now. Will you make any selections in the date field?. If so, what should be displayed when you select "NTS"? I assume that the report should display NTS "Resource" name when the expression is hard-coded with "Budget" FTE value.I have attached a solution again. If this is not working, I would suggest you to explain me what should be displayed when you make selections .

[posywang]

Thank you Tamil, it works!

[tamilarasu]

Great!! I would suggest you to some in-depth testing by making selections. If you have any issues let me know. Happy Friday and a nice weekend, XIA!!!!