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: 
Not applicable

How to use calculated dimensions with proper example in Qlikview

Dear All,

Can anyone explain me how to use calculated dimensions concept in Qlikview.

Thanks & Regards

Vikas

2 Replies
Not applicable
Author

Say for eg, you need catagorise Age into different agae groups:

if(age<16,'Children','Adult').

Regards,

Kiran.

Not applicable
Author

Hi, look bellow what it is said on Qlikview Help about CalculatedDimension:

AddCalculatedDimension:

“Adds a new dimension  and opens it for editing in the Edit Expression 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 aggr function can be included for achieving  nested aggregation. Calculated dimensions will only work in QlikView versions  7.5 and later.”

I  have included a very simple example where I wrote an expression on the dimension  “DDate” to obtain the 'calculated dimensions' Time: (=Date(Date(DDate),'hh:mm:ss TT')

Regards.