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

use expression as a dimension

Hi all,

I would need to use the results of an expression as a dimension:

example:

(if(dimension='data',1,0))

This give me a list of all emloyees with a dimension field specified as data and how many times the instance is per employee.

Employee     count

ID405           33

ID302           1

ID010           22

now I would need to group:

Data Count     No of Employees

1                         20

22                         55

and so forth..

Help please

1 Solution

Accepted Solutions
Not applicable
Author

Hello Markus,

Please see the attached QVW for the solution.

View solution in original post

2 Replies
Not applicable
Author

Hi Markus,

Try this..

load  dataCount ,

        count(Employee) as [No of Employess]

resident table

group by datacount ;

hope this helps

Regards,

Koti

Not applicable
Author

Hello Markus,

Please see the attached QVW for the solution.