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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Sa_Rah
Contributor III
Contributor III

Dimensionality() with calculated dimensions

Hi

Is it possible to use Dimensionality() with calculated dimensions? 

The below formula works if I have fixed dimensions Division and Specialty, but if I use 

=pick($(vDimension1), Division, Specialty)

to select the two dimensions, it doesn't seem to work. Help! 

if (Dimensionality() = 1, NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( total <Division> distinct [EmpNo]),'0.00%'),


if (Dimensionality() = 2, NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( total <Division,Specialty> distinct [EmpNo]),'0.00%'),


NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( distinct [EmpNo]),'0.00%')))

Thanks

Sarah

Labels (3)
0 Replies