This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Can anyone tell me why I can't use Min(adate) in a calculated dimension?
='Contract End from ' & ' ; Contract Types ' & GetFieldSelections([Contract Type])
='Contract End from ' & min([Contract End]) & ' ; Contract Types ' & GetFieldSelections([Contract Type])
I didn't hear it but i think you are going for a min date across all records in the current selections, not a dimensional mininmum. if that is the case this works in your sample as well:
=date(Min( total EndDate))
View solution in original post
Does it give you an error or the result is not the expected?
Try replacing min([Contract End]) by:
min(Aggr([Contract End], [Contract End]))
Do you want it to be the min out of every date in the chart , in the current selection, in the date model ?
See below for min date in a year and min date in whole chart . expressions are in the column header:
Hi, the main problem is that I get the error
// Error in calculated dimension
Can you share a sample (qvw) ?
Is this what you need ?
Calculated dimension formula: =date(aggr(Min(EndDate),Customer))
Can you try it using a variable?
Please check attached qvw.
Interesting idea, it certainly solves the syntax error, but no use because the dim has to be dynamic - based on the selection.
But where have you set the variable. I hope not in the load script.
Because if it is from the - "Settings -> Variables Overview", those variables are dynamic and it will change as per your selection of the field used in variable definition.