Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sindus123
Contributor III
Contributor III

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

sindus123
Contributor III
Contributor III
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

sindus123
Contributor III
Contributor III
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

sindus123
Contributor III
Contributor III
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

sindus123
Contributor III
Contributor III
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