Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Can we use set Analysis/Expression in advanced search dialog box?

For example, I want Employee Names who belong to Qlikview technology.

I have fields Employee Names and Technology.

I click on advanced search for Employee Names list box and will I able to write set expression as 'Technology = Qlikview' ?

(Ignore my syntax).

Kindly suggest.

2 Replies
Highlighted

Re: Can we use set Analysis/Expression in advanced search dialog box?

Perhaps this?

Only({<Technology = {'Qlikview'}>} [Employee Names])


Or

Only({<[Employee Names] = P({<Technology = {'Qlikview'}>} [Employee Names]) [Employee Names])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist II
Specialist II

Re: Can we use set Analysis/Expression in advanced search dialog box?

I just tested this and it look like you can do that -

Capture12.PNG

For String -

Capture12.PNG