-
Re: Round() help
Petter Skjolden Apr 13, 2018 3:44 AM (in response to Mahitha M)I think this is what you are looking for:
Round( Sum( If( [name] = 'valuerisk' , [Value] , 0 ) ) / 1000 , 0.01 )
You might have to add Num for the display:
Num( Round( Sum( If( [name] = 'valuerisk' , [Value] , 0 ) ) / 1000 , 0.01 ) , '0.00' )
-
Re: Round() help
Mahitha M Apr 13, 2018 4:26 AM (in response to Petter Skjolden )Hi Petter,
Thanks a lot for your reply. Its working fine. Some expression contains like below.
Could you please help me to convert this || 'Y' as well. Cant create new thread again
round( Sum ( decode ( [name] , 'valuerisk' || 'Y', [Value] ,0 ) ) /1000, 2 )
-
Re: Round() help
Petter Skjolden Apr 13, 2018 4:31 AM (in response to Mahitha M)|| is Oracle string concatenation operator for joining two strings together.
So it would be the same as:
Round( Sum( If( [name] = 'valuerisk' || 'Y' , [Value] , 0 ) ) / 1000 , 0.01 )
That should be exactly the same as:
Round( Sum( If( [name] = 'valueriskY' , [Value] , 0 ) ) / 1000 , 0.01 )
-
Re: Round() help
Mahitha M Apr 13, 2018 4:48 AM (in response to Petter Skjolden )Thanks petter
Num( Round( Sum( If( [name] = 'valuerisk' , [Value] , 0 ) ) / 1000 , 0.01 ) , '0.00' ) THIS EXPRESSION is working fine in UI
but when I have moved the same expression to backend script its showing invalid expression. Actually to apply group by logic I have to move to script only there is 50 expressions like this.
could you please help me on this.
-
Re: Round() help
Jonathan Dienst Apr 13, 2018 5:03 AM (in response to Mahitha M)In SQL (and in Qlik), when you include an aggregation function like Sum(), all other fields not in some aggregation need to be in the Group By. That is how it is.
-
-
-
-
-
Re: Round() help
Jonathan Dienst Apr 13, 2018 4:59 AM (in response to Mahitha M)I think Petter has covered this perfectly