Data about a user's employee in a chart

Wed, 15 Jun 2011 13:50:51 GMT

Hi there,

I am trying to create a chart displaying data about a user and of their employees. The hierarchy is defined through the "Fact" table (according to the star schema, its a brand new thing to me, and I hope that I understood it well.) I transformed my source SQL database to the following :

The tables User and UserChild are actually the same.. (FirstNameChild = FirstName, etc.), it's the only way I found in order to associate the IdUserChild to the associated FirstName and LastName. What I would like to do now is to create a chart that counts the rows in DailyActivity and Activity_Contact associated with each IdUserChild (well.. IdUser in fact.. That's my problem.) The hierarchy is defined as follow in the Facts table:

IdUser	IdUserChild	IdDailyActivity	IdActivityContact
2	11
1	3
1	4
1	5
2	9
11		5
11		6
3		7
3			55
4			56

I have a variable $(userid), and I would like all their child to be displayed in a chart with their associated number of IdDailyActivity and IdActivity_Contact. My problem is that my dimension in the chart is associated with IdUser, and not IdUserChild. That means that every columns will be about the IdUser pointed by my variable $(userid), and not the actual employees of my user.. And nothing is associated with IdUserChild in my schema, but the User table. I hope I made myself clear.

My dimension is defined as follows : =if(IdUser=userid, IdUserChild) (this way, I am able to display the user's employee in a chart, and using FirstNameChild and LastNameChild I'm able to display their name, but I don't want to import my data twice in order to associate everything with IdUserChild too)

Any help is much appreciated.

Julian

Re: Data about a user's employee in a chart

Fri, 08 Sep 2017 13:43:54 GMT

Hello Juliiian,

Even I am having the same query. If you have found a solution please guide me.

I am also using Fact table with star schema as explained by you and while associating, I am able to associate only one column and not multiple columns.

Could any one please help on how to do this ?

topic Re: Data about a user's employee in a chart in QlikView

Data about a user's employee in a chart

Re: Data about a user's employee in a chart