Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

I wanna show the particular field values

Dear Friends,

I wanna show the particular field values.

Eg:

Emp_Id

T001       

T002      

T003      

T004        

TV003     

TV004      

TV006       

T008        

TV007       

T012       

TV002

TV001

Here I need to show the Emp_Id which are Start with TV only. I already done it in script side by using Where([Emp_id] like 'TV*');

But I need it in UI side is it possible if possible means can you please tell me how to do..........

1 Solution

Accepted Solutions

Re: I wanna show the particular field values

You can try using it like this:

If(WildMatch(Emp_Id, 'TV*'), TrueCondition)

4 Replies

Re: I wanna show the particular field values

You can try using it like this:

If(WildMatch(Emp_Id, 'TV*'), TrueCondition)

hrlinder
Honored Contributor

Re: I wanna show the particular field values

you can try the calculated dimension

if (left(Emp_Id,2)='TV',Emp_Id)

stigchel
Honored Contributor

Re: I wanna show the particular field values

In a dimension

If(Left(Emp_Id,2)='TV',Emp_Id,Null())

or even better in expression of a chart e.g.

Sum({<Emp_Id={'TV*'}>} Sales)

Re: I wanna show the particular field values

If [Emp_id] is a dimension then write as calculated dimension:

If( Left([Emp_id],2)='TV', [Emp_id], Null())

and check the box "Suppress null values"

let me know

Community Browser