Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

AddCalculated Dimension and enable condition ??

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

1 Solution

Accepted Solutions
vvvvvvizard
Partner - Specialist
Partner - Specialist

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

View solution in original post

4 Replies
Ralf-Narfeldt
Employee
Employee

This is what the QlikView help says:

1.

"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.

2.

"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.

Not applicable

Hi

Please check this link for Calculated Dimension of the chart

1)

http://qlikshare.com/247/


2)

QlikView Maven: Calculated Dimensions to Show Things Satisfying a Condition

3)

Calculated Dimensions | QlikView Help, Tips & Hints


Please Check the Attachment file

It is An Example Data for enable condition


vvvvvvizard
Partner - Specialist
Partner - Specialist

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

vvvvvvizard
Partner - Specialist
Partner - Specialist

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