Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variable with expression.

Hi,

I have a strange problem.

I create a variable to calculate the total of a selection:

Variable name: vAntal

=sum(ST0QO1)

When I use the variable in a table anf I do this:

sum(Quantity) / $(vAntal)

It dont work! I dont know why, I did this many times without problem.

If I write this (without DSE, Dollar Symbol Extension) it work!

sum(Quantity) / vAntal

I use Qlikview 12 SR2 but it work fine with other table/data.

You can try with the sample that I attached.

Anyone have a idea?

Thank you!

Best regards.

11 Replies
vishsaggi
Champion III
Champion III

What is your expected output?

Anonymous
Not applicable
Author

I dont know, it is a numeric integer field but it is possible.