Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Can anyone explain me how to use calculated dimensions concept in Qlikview.
Thanks & Regards
Vikas
Say for eg, you need catagorise Age into different agae groups:
if(age<16,'Children','Adult').
Regards,
Kiran.
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. |