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: 
CuriousGeorge
Contributor II
Contributor II

Date in set expression - pivot table

Hi, I want to be able to use year/quarter/month in a set expression to display a column field. 

if it is on Aug-2021, then display $10,000 for instance. 

How can I make it work? 

 

 

 

If(Year(CreatedDate) = '2021' 
	and 'Q' & ceil(month(CreatedDate)/3) = 'Q3'
	and Month(CreatedDate) = 'Aug', 10000, '')

 

 

CuriousGeorge_0-1640096990176.png

 

1 Solution

Accepted Solutions
CuriousGeorge
Contributor II
Contributor II
Author

I solve my own issues, just insert if else statement on load script and use it on my set expression. I would still eager to know how we can use year/quarter/month (pivot table) on a set expression (if anyone has any idea)

View solution in original post

1 Reply
CuriousGeorge
Contributor II
Contributor II
Author

I solve my own issues, just insert if else statement on load script and use it on my set expression. I would still eager to know how we can use year/quarter/month (pivot table) on a set expression (if anyone has any idea)