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: 
socura
Contributor
Contributor

full set of dimensions with a complex formula

Hi,

i would like to create a bar chart with fixed values of all dimensions just like sum({1} amount).

But how do I do that with a more complex formula?

=sum(#HNR_Istbestand) /sum({<VK.Tätigkeitsliteral={'Technik'}>}[VK.VK-Wert2])

Greetings

Mario

1 Solution

Accepted Solutions
sunny_talwar

This

=Sum({1} #HNR_Istbestand)/Sum({1<VK.Tätigkeitsliteral = {'Technik'}>}[VK.VK-Wert2])

View solution in original post

2 Replies
sunny_talwar

This

=Sum({1} #HNR_Istbestand)/Sum({1<VK.Tätigkeitsliteral = {'Technik'}>}[VK.VK-Wert2])

socura
Contributor
Contributor
Author

I had to know that. One of these days...;-)

Thank You very much!