Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Can anyone help me in writing expression?

Hi All,

I have one scenario like below.

I have one field as below

EMP NAME

satish

raju

swathi

priyanaka

....

I used one function

=GetFieldSelections(EMP NAME)  to get the data related  to emp name when i clicked on emp name and it is working

fine. If I am not clicking on any emp name then it is showing "

- " symbol. Now i want to display the some text in place of "-" when i am not selecting the any field value in empname table.

Please help me on this?

Thanks,

Durga


1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=if(getselectedcount([EMP NAME]),getfieldselections([EMP NAME]), 'MyAlternativeTextHere')


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

=if(getselectedcount([EMP NAME]),getfieldselections([EMP NAME]), 'MyAlternativeTextHere')


talk is cheap, supply exceeds demand
durgabhavani
Creator III
Creator III
Author

Thanks a ton! Gysbert!