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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
eli_K12
Contributor
Contributor

Non calculated dimensions ignoring selection

Hello. 

I am trying to have the dimension Purchase requester ignore all those fields when selected. They are irrelevant and when I select one of them it is causing null data because i know it is there. This is not a calculated field. Does anyone see anything wrong with this or if this is the effective strategy for what I am trying to do. Any assistance would be greatly appreciated. 

=Aggr(Only({<[Month]=, [Year]= ,QTR= ,[Month Num]= ,[Month -Short-]= ,Month= ,[GL Period]= ,[CC]= ,[GL Act]= , [PO Creation Date] = {"=Year(Only({1}[PO Creation Date])) >= $(v3PrevYear)"}>}[Purchase Requester]),[Purchase Requester])

Thank You

0 Replies