Perform selection without changing values

[Kushal_Chawda]

Hi all,

Please find the attached qvw. I have a requirement like, when I do any selection , selection should happen but the original values should

not change. for example

when I select Date = 1/2/2016, I get the values as below

but I need the below values for when I select Date = 1/2/2016 (refer to original table without any selection)

when I select Date = 1/2/2016 3:00:00 PM, I get the values as below

but I need the below values for when I select Date = 1/2/2016 3:00:00 PM (refer to original table without any selection)

I am not sure I can I achieve this. It would be a great if someone can help me.

Note: This calculation cannot be performed in script.

[Kushal_Chawda]

Hi Gysbert,

Thanks for your response.But here I have just shown two selection ,actually there will have many selections, so highlighting will not be a good solution in case if there are lot many rows in table, user may need to scroll as there will have specific sort. Also calculation I am showing here are the steps to go to final calculation. That calculation will be displayed in guage. I can see the solution in script, but in calculation there are two user inputs from front end which are having 64 combination. Only way I can see is to perform cross join of these inputs, so that for each combination calculation will be performed. Issue here is the number of rows will always be multiplied by 64 using cross join. So i am bit worried now.

[Kushal_Chawda]

Hi Stefan,

Thanks for your response, but as  Sunny said, most of the calculations are self referencing, due to which putting actual expression will not give correct result. In script, I can do it by using cross join. But as there are 64 combination of user inputs number of rows will get multiplied by 64. Do you have any other better way to handle user inputs in script?

[Kushal_Chawda]

sunny bhai, thanks for your help