Grouping ( ordering?) usernames Qlikview

tomovangel — Wed, 25 Nov 2020 16:16:04 GMT

Hello dear community, I am new to Qlikview and I am still learning of the possibilities of this amazing associative engine.

in my script I have

LOAD

NUMBER as NUMBER_LAB,

"LABOR_DATE",

Year("LABOR_DATE") as YEAR_LABOR_DATE,

num(Month("LABOR_DATE")) as MONTH_LABOR_DATE,

Day("LABOR_DATE") as DAY_LABOR_DATE,

OPERATOR,

"HOURS_WORKED";

This is the table for service requests, in the field Operator i have different values for 1 user.

For example we have the person Angel Tomov, under 3 names

- Angel Tomov

-Atomov

-angeltomov

Can i write a script or an expression into my straight table which visualizes only 1 of these names, for example
wherever Atomov has send a request, QV to show Angel Tomov?

Thanks for your time!

-Angel

Re: Grouping ( ordering?) usernames Qlikview

m_woolf — Mon, 24 Jul 2017 13:16:02 GMT

You can use a Mapping Table

topic Re: Grouping ( ordering?) usernames Qlikview in QlikView

Grouping ( ordering?) usernames Qlikview

Re: Grouping ( ordering?) usernames Qlikview