topic Re: how to solve range Problem in QlikView

how to solve range Problem

Thu, 16 Oct 2014 10:34:48 GMT

Hi All,

Can anyone help me on below issue?

Lets say I have data like this

Part Critical

A High

B Medium

A Medium

C Low

A Low

C High

B High

D High

now i should have a condition such that if all the criticals of particular part is high then it should show High , if the part is having high and medium then it should show medium , if the part has all 3 criticals then it should show Low .

So O/P should be

Part Critical

A Low

B Medium

C Low

D High

Re: how to solve range Problem

anbu1984 — Thu, 16 Oct 2014 11:39:02 GMT

Load Part,If(Critical Like '*Low*','Low',If(Critical Like '*Medium*','Medium','High'));

Load Part,Concat(DISTINCT Critical) As Critical Group by Part;

Load * Inline [

Part,Critical

A,High

B,Medium

A,Medium

C,Low

A,Low

C,High

B,High

D,High

D,High ];

Re: how to solve range Problem

tresB — Thu, 16 Oct 2014 11:50:39 GMT

Straight table:

Dim: Part

Exp: =If(Index(Concat(Distinct Critical, ','), 'Low'), 'Low', If(

Index(Concat(Distinct Critical, ','), 'Medium'), 'Medium', 'High'))

Re: how to solve range Problem

Wed, 22 Oct 2014 09:51:32 GMT

Thanks a Lot Tresesco..Works perfect