topic Table Box properties in QlikView

Table Box properties

Anonymous — Wed, 23 Aug 2017 07:28:23 GMT

Want to know the usage of "Calculation Condition" in table box.

Also want to know can we add a calculated field in a table box, if yes then how?

Thanks

Re: Table Box properties

Anil_Babu_Samineni — Wed, 23 Aug 2017 07:32:52 GMT

Table box doesn't have calculation dimension feature. So, Instead we can go straight table and the usage is very powerful using calc. dimension because we are restrict the data and it is not good to have until unless we don't have option to use in set analysis (Measure)

Re: Table Box properties

tresB — Wed, 23 Aug 2017 07:42:46 GMT

Q1: Usage of 'Calculation Condition' :

You can put a certain condition possibly based on your data when to display the data in the chart and when not (FALSE). For example, you may wish to display the table box data only when a certain field, say Sales has minimum value 100. Then you can put the condition like: =Min(Sales)>=100. If this condition comes true, the tables shows data, if false, then the chart remains without that data and displays a default message 'Calculation condition unfulfilled' (or the custom error message you set).

Q2: No you can't add a calculated dimension in table box, but in a straight table.