Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
intervigilium
Contributor III
Contributor III

Use of column-value in pivottabel

Hi all,

I have created a pivottable, where the columns represents customers within a selection (dynamic).

In every colum i want a expression (sum of values with certain criteria) for that particular customer.

In current version it calculates the sum over all customers because the column (clientnr) is not a selection.

Any ideas ? Am a reel beginner and searched a long time on the forum, but didnt find a simular situation.

I attached a screenshot. The red box represent the total value, but i want that value related to the customer in de column.

Current formule in the variable is:

= Sum( { $<strGrootboekGroupCode= {"HC.1.*" }>}lngGrootboekSaldo)

I'm looking for something like:

= Sum( { $<strGrootboekGroupCode= {"HC.1.*" }>,<Clientnr_=Columnheader>}lngGrootboekSaldo)

Ofcourse the second is not working, only to clearify what i want to achieve

Any help?

11 Replies
intervigilium
Contributor III
Contributor III
Author

Unbelievable......i spend hours on trying....you have the solution in a few minutes!

I'm jealous at your qlikview-knowledge!

Thanks again!

sunny_talwar

No problem at all, I am glad I was able to help and make you feel a little jealous