Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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!