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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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