topic Re: Set Analysis in QlikView

Set Analysis

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

Hi Experts,

Can any one please help me on this. In the below screen shot, when the Category = Electronics and RAG Status= 'R',

I need to show corresponding Product name in the Text Object.

I have tried this expression =MaxString({<Category={'Electonics'},[RAG Status]={'R'}>}[Product Name]). But its showing only

Refregirator not showing Phone.

If I have RAG Status = R for 3 Products I need to show 3 products names in the Text Object.

Thanks in Advance.

tresB — Mon, 30 Oct 2017 05:00:24 GMT

Use concat() instead of maxstring() like:

Concat(Distinct {<Category={'Electonics'},[RAG Status]={'R'}>}[Product Name] , ',' )

madhumitha — Mon, 30 Oct 2017 05:51:53 GMT

Hi Bhavani,

Please find attached workaround.

Hope this helps.

Thanks!