Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hi
Please check this link for Calculated Dimension of the chart
1)
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
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
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