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: 
Not applicable

Min date doesn't work with Sum

Hello All,

I am trying to calculate an indicator using minimum date. So i set a
variable called 'vPeriodStart' like this

vPeriodStart= min(uDAY) and it gives the earliest date back for a selected fiscal period. Now if i want to use this variable like this

sum(if(Opening > $(vPeriodStart)
or ClosingDate
< $(vPeriodStart) ,0,1)) it

does not work. I also tried

sum(if(Opening >min(uDAY) or ClosingDate < min(uDAY),0,1)) but same result it gives me no value back.

i also tried to format date in every
possible way with Date and Date# it does not work. I am confused why i am
unable to use Min(Date) function in sum formula.

now i if set the value of variable

vPeriodStart= today()

vPeriodStart='09.09.2013'

it works

Now i need to make it works with vPeriodStart= min(uDAY) I tried every possible way but it not working. I am wondering if anybody can help me this

Thnaks

10 Replies
Not applicable
Author

swuehl,

u made my day thank you very much.

Regards

Sameer