Dimension Calculation error?

[#1]

Hello Experts,

Can someone tell me whats wrong with this expression as this returns the same numbers. Looks like its calculating correct values for BOOTS, but BP also shows the values of BOOTS.

=if(ValueList('BOOTS')= 'BOOTS',sum({$<NAL2_DESC = {'DUMMY BOOTS'}, NAL3_DESC = {'DUMMY BOOTS'}>}FCT_GROSS_REVENUE),
if(Valuelist('BP')= 'BP',sum({$<NAL2_DESC = {'DUMMY BP'}, NAL3_DESC = {'DUMMY BP'}>}FCT_GROSS_REVENUE)))/1000

[Oleg_Troyansky]

I think if you have ValueList('BOOTS', 'BP'), then you should reference it in the same way in both IF conditions.

Another possibility - if your Set Analysis condition produces an empty set, QlikView will show you all possible values instead - and that's why you might be seeing Boots where you don't expect them...

[#3]

Hello Oleg,

Thank you for the quick reply, Yes I have the Value List right and I was thinking of the second point you mentioned. Can you explain more about that? What happens is when I am writing the expression in a normal Text Box, then I can see numbers but not in the chart for the same expression. I also have the Time Period and TIme Week as other 2 dimensions..do you think thats causing any problem?

[Oleg_Troyansky]

Set Analysis condition works the same way as making selections manually in List Boxes. If you, for example, selected a Customer, and then you try to select a Product that is not associated with the Customer (meaning that the combined condition produces an empty set), QlikView will replace the earlier selection with the later selection, but never show you an empty set. In a similar way, if Set Analysis condition renders an empty set (no data is associated with your condition), QlikView will ignore the condition all together and show you the full data set.

It's hard to guess what the problem might be, without looking into the application. If you can extract a small sample demonstrating the problem, we could possibly find the problem.

[#5 · Accepted solution]

Hello Oleg,

I figured out the problem I had. I was sure something within the expression itself was wrong.. so check the Below:

=if(ValueList('BOOTS','BP')= 'BOOTS',sum({$<NAL2_DESC = {'DUMMY BOOTS'}, NAL3_DESC = {'DUMMY BOOTS'}>}FCT_GROSS_REVENUE),
if(Valuelist('BOOTS','BP')= 'BP',sum({$<NAL2_DESC = {'DUMMY BP'}, NAL3_DESC = {'DUMMY BP'}>}FCT_GROSS_REVENUE)))/1000

I forgot to add BP also to calculate the expression after If(Valuelist('BOOTS').

That solved my problem.