Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Oskar_vl
Partner - Contributor II
Partner - Contributor II

Waterfall Chart two values in value Description

Hey Community,

 

I try to bring two values, one abolute and one percent value in the value description. 

Here is the abolut formula:

 

=num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
,'#.##0 Min. $(vProductionPercent) ')

 

I try it with a variable but then i get two extra 00 in my value. Below how it actualy look like and how it should look like.

 

 

Unbenannt.PNG

 

Any ideas? 

Thank you very much

greetings Oskar

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

try changing your formula to something like below
num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
,'#.##0') & 'Min.' & $(vProductionPercent)
Oskar_vl
Partner - Contributor II
Partner - Contributor II
Author

This is the formula you see on the right in the Chart.
When I use this the description it is perfekt bud the value itself is missing.

num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
)
,'##.##0 Min.')
&
'$(vProductionPercent)'