Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tomovangel
Partner - Specialist
Partner - Specialist

Grouping ( ordering?) usernames Qlikview

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

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

You can use a Mapping Table

View solution in original post

1 Reply
m_woolf
Master II
Master II

You can use a Mapping Table