topic Re: Generate New Column based on other column in QlikView

Generate New Column based on other column

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

Hello All,

I'm pulling some data from a DB as in the below format, and would like to generate a new filed based on the data i have.

Sample Table:

Expected Result:

So, basically if the Product is A, B, C, D i would like to populate the Percentage column as 70 and for all the other Products i would want 85.

Please, suggest the best possible way. Already tried doing Inline Load but, doesn't seem to work some how.

Thanks!!

tresB — Thu, 12 Oct 2017 11:55:48 GMT

Load

Product,

ArtiKelNr,

If(Match(Product, 'A','B','C','D'), 70, 85) as Percentage

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:57:33 GMT

Perhaps this?

If(Match(Product, 'A','B','C','D'), 70, 85) as Column_New

Anonymous — Thu, 12 Oct 2017 12:09:11 GMT

Hi Sai Kumar,

Use the below expression.

=if(match(Product,'A','B','C','D'),70,85)

psk180590 — Thu, 12 Oct 2017 13:37:08 GMT

Thanks All, worked perfectly!!