Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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)