topic use expression as a dimension in QlikView

use expression as a dimension

Thu, 28 Nov 2013 11:30:52 GMT

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

Thu, 28 Nov 2013 11:40:29 GMT

Hi Markus,

Try this..

load dataCount ,

count(Employee) as [No of Employess]

resident table

group by datacount ;

hope this helps

Regards,

Koti

Thu, 28 Nov 2013 11:45:44 GMT

Hello Markus,

Please see the attached QVW for the solution.