Variable with expression.

[Anonymous]

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.

[Anonymous]

Sorry,

=sum(Quantity)

[its_anandrjs]

In the variable definition remove equal sign before the variable defintion and check the variable output.

[its_anandrjs]

Or in expression simple this

=$(vAntal)

[Anonymous]

I use the = sign to have the total calculated. I know that I can do also this:

sum(Quantity) / sum(TOTAL Quantity)

but it is possible to do with variable and = sign.

If you try the attached it work.

[Anonymous]

Anyone that have an idea?

Thank you!

[prieper]

not quite sure, why - but you may try to enclose in brackets.

sum(Quantity) / ($(vAntal))

[Anonymous]

Thank you for your answer.

I try but dont work.

A mistery...

[Anonymous · Accepted solution]

I dont know why but I try and it work with this:

=sum(Quantity) / num($(vAntal),'###')

Good to know!

[Anil_Babu_Samineni]

May be format issue, Good it worked