Help me to make improve this code

Wed, 26 Oct 2011 18:30:45 GMT

Dears, I'm actually using the following code to calculte the favorability of a item. But I'm seeing that it's taking to much time to calculate and I do belive that I can do it better. So, Do you have any sugestion to calculate it in another way?

=
(
((((Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness]))
-(Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])))))
+
((((Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Convenient locations]))
-(Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])))))
+
((((Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Overall experience]))
-(Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])))))
+
((((Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Slot availability]))
-(Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])))))
+
((((Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Workmanship]))
-(Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])))))
)

(
((((Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness]))
+(Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Neutral"}>} [ Embraer Owned Service Center Network AOG responsiveness])))))
+
((((Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Convenient locations]))
+(Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Neutral"}>} [ Embraer Owned Service Center Network Convenient locations])))))
+
((((Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Overall experience]))
+(Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Neutral"}>} [ Embraer Owned Service Center Network Overall experience])))))
+
((((Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Slot availability]))
+(Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Neutral"}>} [ Embraer Owned Service Center Network Slot availability])))))
+
((((Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Workmanship]))
+(Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Neutral"}>} [ Embraer Owned Service Center Network Workmanship])))))
)

Thank you so much for your attention,

Best regards

Help me to make improve this code

Wed, 26 Oct 2011 19:16:26 GMT

On a quick look I can advice you that set analysis can accomodate multiple conditions bringing down your code size. For example your first term

Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])

Can be replaced with

Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied","Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])

Hope it helps,
Kiran

Re: Help me to make improve this code

llauses243 — Wed, 26 Oct 2011 21:19:14 GMT

Hi,

For me much code make dificult test & maintenance

To divide in columns and each a expression improvement in clearity moreover easy test & maintenance

By In-memory not affect the performance

Pls to see object attached for more info.

Good luck, Luis.

Is possible also to use variables

topic Re: Help me to make improve this code in QlikView

Help me to make improve this code

Help me to make improve this code

Re: Help me to make improve this code