topic Re: Create a new attribute from current attributes in App Development

Create a new attribute from current attributes

Melon_96 — Mon, 09 Mar 2020 15:31:59 GMT

Hello to everybody!

I am new in Qlik Sense and I have a question, I hope you can help me.

Right now I have a table named Product. In the Product table I have an attribute named Stock. This stock is going to be updated everyday and it has to options. The value of the stock can be Yes or Not. My goal is to create a new attribute in the table Product where if the value of stock is Yes the value of the new attribute is 1 and 0 if the value of stock is Not.

Is it possible to create that new attribute from the table itself? If so, how can I create that new attribute?

Thank you very much in advanced!

Re: Create a new attribute from current attributes

dplr-rn — Mon, 09 Mar 2020 16:47:22 GMT

Maybe i am misunderstanding some underlying complexity.

but typical way to do this is like below

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/if.htm

load attr1, . //Other columns/attributes , Stock, if(Stock = 'Yes',1,0) as StockFlag ; sql load * from ProductTable;

Re: Create a new attribute from current attributes

Melon_96 — Tue, 10 Mar 2020 08:42:54 GMT

Thank you very much, problem solved!

Re: Create a new attribute from current attributes

dplr-rn — Tue, 10 Mar 2020 11:18:19 GMT

Mark the answer as solution please