topic Re: How do I? in QlikView

How do I?

Sat, 29 Sep 2012 12:55:49 GMT

My fact table has LastModifiedbyUser Code. When I use it as a list box to narrow the fact records down – I want to not see User Names from the User Master not the User Codes. I want to see the User Names in the List Box. I have the User master also loaded.I don't want to see the entire User Names - just the ones that have modified records in the fact table.

Appreciate the help.

Re: How do I?

Jason_Michaelides — Sun, 30 Sep 2012 11:56:48 GMT

Assuming your fact table has and ID field, you could use an expression in your list box like:

If(Not IsNull(FactID),UserCode)

Hope this helps,

Jason

Re: How do I?

jagan — Sun, 30 Sep 2012 12:11:04 GMT

Hi,

You can load only the User Names from master data which is having the LastModifiedbyUser code by using the Exists(). Check help file from example.

Ex:

LOAD

LastModifiedbyUserCode AS UserCode,

FROM Table;

Master:

LOAD

UserCode,

UserName

FROM Master

WHERE Exists(UserCode);

Hope this helps you.

Regards,

jagan.