Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fig1
Contributor III
Contributor III

Simple field formula

I have created a field called Specialty groups (in the load script) which contains  a number of units within it.  How do I create a formula to just bring through one of the specialty groups in my analysis?

E.g. Specialty Groups = Surgical, Medical, Paediatrics, Mental Health. I only want to bring through data for 'Medical'. If  I use Speciality Groups = 'Medical' it will bring through medical but group all the others into a separate column.

1 Reply
Gysbert_Wassenaar


@Fig1 wrote:

If  I use Speciality Groups = 'Medical' it will bring through medical but group all the others into a separate column.


And what happens if you also uncheck the "Include null values" setting for that dimension?


talk is cheap, supply exceeds demand