topic Re: AddCalculated Dimension and enable condition ?? in QlikView

AddCalculated Dimension and enable condition ??

nikhilgarg — Tue, 17 Mar 2015 08:53:05 GMT

Hey,

Can anyone help em understanding :

1: What is AddCalculated Dimension and when we should use it?

2: What is enable condition and when we should use it.

thanks

Re: AddCalculated Dimension and enable condition ??

Ralf-Narfeldt — Tue, 17 Mar 2015 09:01:33 GMT

This is what the QlikView help says:

"Adds a new dimension and opens it for editing in the Edit Expression Dialog dialog. A chart dimension is often in a single field, but can also be dynamically calculated. A calculated dimension consists of an expression involving one or more fields. All standard functions may be used. Aggregation functions may not be used, but the Advanced Aggregation function can be included for achieving nested aggregation."

So you use it when you need a dimension calculated from one or more fields.

"Marking this check box hides or shows the dimension dynamically, depending on the value of a condition expression entered, by clicking the ... button in the edit box below."

So you use it when you need to hide a dimension, based on an condition expression.

Re: AddCalculated Dimension and enable condition ??

Tue, 17 Mar 2015 12:07:36 GMT

Please check this link for Calculated Dimension of the chart

http://qlikshare.com/247/

QlikView Maven: Calculated Dimensions to Show Things Satisfying a Condition

Calculated Dimensions | QlikView Help, Tips & Hints

Please Check the Attachment file

It is An Example Data for enable condition

Re: AddCalculated Dimension and enable condition ??

vvvvvvizard — Tue, 17 Mar 2015 12:11:51 GMT

Good day , most of the time the dimensions we use in Qlikview are already there ,when you create a chart you add Year as dimension , sometimes we want a dimension thats not there , like Num( year) + 50 , we want to add 50 years to the timeline , then we add a calculated dimension

Conditional = 0 to hide and =1 to show , set a chart condition to 0 usinga varible a=0 and it will be hidden , change the value of the variable to 1 at any time in the script , when a user clicks something to show the chart based on a action or user input

Re: AddCalculated Dimension and enable condition ??

vvvvvvizard — Tue, 17 Mar 2015 12:19:04 GMT