Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

New Column Creation

Hi Everyone,

I have a requirement that i want to create a new output column using existing Equation column .

The output column  is replaced with id names excluding _YY. Please find the attached sample data.

    

IDID nameEquationNew Output Column
124Days Sales([91_YY])/([225_YY]/365)(Annual/ Annual days/365)
91AnnualNullNull
225Annual daysNullNull
4826Sales(([225_YY]-[225_YY-1])/[225_YY-1])*100(([Annual days]-Annual days-1])/[Annual days-1])*100
729Inventory([147_YY]/[236_YY])*100([Inventory Carrying]/Total Product Revenue
])*100
147Inventory CarryingNullNull
236Total Product RevenueNullNull

For example :

([147_YY]/[236_YY])*100

ID 147= Inventory Carrying

ID 236= Total Product Revenue

New output column should be:(Inventory Carrying/Total Product Revenue)*100

Thanks in advance

1 Solution

Accepted Solutions
padmanabhan_ram
Creator II
Creator II

Hi Kavya,

You ca replace the ID's with ID Name in the IF statements. Maintain the ID Names in the excel with variables and replace the names by variables just for better performance.

I hope you do not have 1000 ID names, if so then you have to find some other way to do it.

Br,

Padmanabhan

View solution in original post

10 Replies
padmanabhan_ram
Creator II
Creator II

Hi Kavya,

can you please share the expected table in an excel with sample data and output including calculations.

Br,

Padmanabhan

Anonymous
Not applicable
Author

Hi,

Please find the attached sample data and output column.

 

New Output Column
(Annual/ Annual days/365)
Null
Null
(([Annual days]-Annual days-1])/[Annual days-1])*100
([Inventory Carrying]/Total Product Revenue
])*100
Null
Null

Calculation:

([147_YY]/[236_YY])*100

ID 147= Inventory Carrying

ID 236= Total Product Revenue

New output column should be:(Inventory Carrying/Total Product Revenue)*100

Thanks,

Kavya

padmanabhan_ram
Creator II
Creator II

hi kavya,

I can understand that 147, 236 are ID's but what is _YY?

Br,

Padmanabhan

Anonymous
Not applicable
Author

HI Padmanaban,

_YY is in Equation column .The output column should be  replaced with id names (Annual/ Annual days/365) and _YY should be removed from Equation column..


For example :

([147_YY]/[236_YY])*100

(Inventory Carrying/Total Product Revenue)*100

padmanabhan_ram
Creator II
Creator II

Hi Kavya,

please find the attached file and let me if this is what is expected.

Br,

Padmanabhan

Anonymous
Not applicable
Author

Thanks for your reply.

I am expecting  new column to be like this (Inventory Carrying/Total Product Revenue)*100.

padmanabhan_ram
Creator II
Creator II

Please find the attached, let me know if it matches your expectation.

Br,

Padmanabhan

Anonymous
Not applicable
Author

Hi Padmanabhan,

Thanks for the answer.

I am having  more than 1000  Id's .Each time i cannot hard code the ID.Please let me know is there any way to replace ID with ID names,

Thanks

padmanabhan_ram
Creator II
Creator II

Hi Kavya,

You ca replace the ID's with ID Name in the IF statements. Maintain the ID Names in the excel with variables and replace the names by variables just for better performance.

I hope you do not have 1000 ID names, if so then you have to find some other way to do it.

Br,

Padmanabhan