Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Community Office Hours: Join us on July 9th, 2025 - REGISTER HERE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

help in set analysis

got a pivot table with Dimensions TPK, Nickname

each TPK and Nickname has one Functional Contact

I want to display all Fucntional contact where Module = ' ' or null and functional contact is not null

I managed to write this:

Only

  (

  {

  ($-<MODULE={'*'}-{''}>)

  *

  <

  IS_TPK_DESCRIPTION={1}

  ,TPK_QC_TEAM={'*'}

  ,RECORD_TYPE={'pushed job'}

  ,TPK_FUNCTIONAL_CONTACT={'*'}-{''}

  >

  }

  TPK_FUNCTIONAL_CONTACT

  )

and it is working just fine but now I want the result to be affected only by year and month of the master calendar

can someone help?

I can walk on water when it freezes
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps this document helps: Ignore all selections except some specific fields using Set Analysis


talk is cheap, supply exceeds demand