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.
Hello Experts QV,
How we could transform an expression into a dimension in order to use it in orhers expressions ?
Specially, I want to transform this expression if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)
Thanks a lof for your help.
You enter in a logical loop because expressions are computed on dimension so your expression
if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)
count and extract min values for which dimension?
You can use expressions in dimension but not with aggregate functions ... try to use variables!!!
Thank you for your feedback.
My dimension is Period_MonthName ( it's equal to MonthName(Date)).
I have exactly this problem
In a pivot table I have for example
MyMonth => if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)
I want to add a count(Applications) by MyMonth (that is an expression in my case, this is my problem).
The resulat that I want
Do you have an idea?
PS/ I just start to working with QlikView ..
You can try the aggr()-function as an expression, or you can make a new table (in the script) that is already aggregated and use that.
Count(Applications) as Applications_count