topic Re: Calculation condition in Table box in QlikView

Calculation condition in Table box

Fri, 28 Aug 2015 22:31:43 GMT

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

Re: Calculation condition in Table box

Oleg_Troyansky — Fri, 28 Aug 2015 22:36:20 GMT

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

Re: Calculation condition in Table box

Fri, 28 Aug 2015 22:52:27 GMT

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

Re: Calculation condition in Table box

qlikviewwizard — Sat, 29 Aug 2015 02:03:32 GMT

Hi,

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

Re: Calculation condition in Table box

Wed, 30 Mar 2016 12:11:17 GMT

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,