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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
chibi
Creator
Creator
‎2021-12-15 03:39 AM

Set Analysis

How do I make sure that the draw_end_date only take the data for the current month selected despite the draw ID? 

Avg(Aggr((Sum(tkt_amt))/count(draw_id),draw_end_date))

How do I make it like a where clause draw_end_date= current Month selected?

Avg(Aggr((Sum(tkt_amt))/count(draw_id),draw_end_date==CurrentMonth selected))

333 Views
0 Likes
0 Replies