Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
rolandg1881
Creator
Creator

set analysis date

Hi!

Following question:

I have this formula

sum(
{< Cust_number = {'70407'},[CLM_Type]={'claim'} >}
[CLM_PickupTime])
/
sum(
{< Cust_number = {'70407'},[CLM_Type]={'claim'} >}
[CLM_Counter])

 

Then i have the value CLM_Date (MMM-YY example May 21)  and i want to see the result from the formula where the date is bigger then May 21. 

But i dont know which syntax i have to use in the formula for this date expression...

Thank you for answers.

Greetings Roland

Labels (1)
0 Replies