I wanna show the particular field values

[#1]

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..........

[sunny_talwar · Accepted solution]

You can try using it like this:

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

[Anonymous]

you can try the calculated dimension

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

[stigchel]

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)

[alexandros17]

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