Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

This

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

View solution in original post

2 Replies
Highlighted

This

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

View solution in original post

Highlighted
Contributor
Contributor

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

Thank You very much!