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.
I would like to create an expression that would give me the total number of yellow boxes (any value greater than 40) for all Test #'s in the example below. So the desired number for the example below would be 12. I am grateful for any suggestions.
May be this
Sum(Aggr(If(Sum(Value) > 40, 1, 0), Example, [Week Year]))
View solution in original post
Do you need this expression in the front end or the back end?
Do you want to display the number 12 or Count of yellow boxes in a text box? May be you can try like:
= Count(IF(Aggr(Sum(Value), WeekYear) > 40, 1))
Count(If(Sum(Aggr(Sum(Value),Example,Week)) > 40))
You saying you can use this expr in text box? If yes, may be a slight addition to your expression else might throw an error. As IF should return some value.
Can you check your expr will throw an error with Nested Aggr Not allowed or a script error. Just wondering.
= Count(Sum(Aggr(Sum(Value),Example,Week)) > 40))
Need to fill in the values for this pivot table.
I at least get a value in return with this, but it gives me 5.
I would try to do it in a crosstable in the data load editor.
then do the aggregation in the front end
Thank you Sunny this worked great! I tried it for =0 and <2 and it didn't work for some reason though.