Calculation condition in Table box

[#1]

Hi all,

How can i add a calculation condition in a table box, with following condition

     select values when DivisionID is equal to 1 or 2. And if calculation condition does not work then display a message saying that         Calculation condition unfulfilled. Or else display a custom message saying that please select only DivisionID 1 or 2 to see the data.?

Thanks,

Sat

[Oleg_Troyansky]

I have a feeling that I answered exactly this question just yesterday...

Table Box properties, General Tab bottom left corner, - Calculation Condition. Right across from it - the Error Messages button.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[#3]

Thanks for the reply. what is the correct expression i should write, i am not getting desired result.

[qlikviewwizard]

Hi,

Sat Raj, Can you attach the sample file to demonstrate your issue?

[#5]

In the Chart Properties, General Tab, add the calculation condition:

DivisionID = 1 or DivisionID = 2

Press on the button "Error Messages" and override the default message for "Calculation Condition unfulfilled".

Cheers,