This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
For example :
ID 147= Inventory Carrying
ID 236= Total Product Revenue
New output column should be:(Inventory Carrying/Total Product Revenue)*100
Thanks in advance
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.
View solution in original post
can you please share the expected table in an excel with sample data and output including calculations.
Please find the attached sample data and output column.
I can understand that 147, 236 are ID's but what is _YY?
_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..
(Inventory Carrying/Total Product Revenue)*100
please find the attached file and let me if this is what is expected.
Thanks for your reply.
I am expecting new column to be like this (Inventory Carrying/Total Product Revenue)*100.
Please find the attached, let me know if it matches your expectation.
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,