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 want to show count(products) based on 'sales < target'
exp : if(sales<target,count(products))
Here for product 'p1', region 'c' sales is less than the target,but it aggregated with region 'a' .count it is showing 0, because target is aggr .
i want to show this in text box.
Can you post your complete expression which you are trying.
i am using this exp;
thanks for the reply,
it value showing '2',but it should be 1,because for region'c' is only not reached the target.
sorry if i select products 'p1
That's very interesting. It's showing 1 as result here based on the example data you posted.
Can you elaborate your Query. As you said aggregation by region is giving count 0 . But this should give the count.
Create an alternate state
Setting - Document Properties-Alternate state—Add..
And then go to the textbox with the expression Gysbert has provided and choose from dropdown this State