topic Re: set analysis with expression variable in QlikView

set analysis with expression variable

Tue, 27 Oct 2015 18:34:46 GMT

I have an expression called vMaterialCost wwhcih is a sum of my material costs. This variable works fine in my expression but we just added a selction criteria called current/Prior month. In my trending charts, I need to use my vMaterialcost variable as an expression regardless of the value selected in current/prior month

I have tried

=Only({<[Current/Prior Month]={$1} >} $(vMaterialCost))

but that did not seem to work

Assistance is appreciated

Re: set analysis with expression variable

sunny_talwar — Tue, 27 Oct 2015 18:43:41 GMT

Can you share your expression for vMaterialCode?

Re: set analysis with expression variable

maxgro — Tue, 27 Oct 2015 18:47:02 GMT

how is defined vMaterialCost?

to disregard the current/prior month you can use an expression (MaterialCost is a field) as

sum( {$ <[Current/Prior Month]=>} MaterialCost)

Re: set analysis with expression variable

Tue, 27 Oct 2015 18:48:46 GMT

sum([Material Cost Amount])

and thsi expression is used throughout the applciation and do not want to change it

Re: set analysis with expression variable

sunny_talwar — Tue, 27 Oct 2015 18:52:07 GMT

I think you will have to make the change to your variable itself or just write the whole expression again with the new set analysis. The way you are trying to do won't work.

=Sum({<[Current/Prior Month] = >}[Material Cost Amount])

Re: set analysis with expression variable

maxgro — Tue, 27 Oct 2015 19:06:03 GMT

If you don't want to change the variable you have to create a new variable with Sunny's expression