topic Re: aggr in count in QlikView

aggr in count

Fri, 27 Feb 2015 12:25:10 GMT

Hi All,

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.

any help

PrashantSangle — Fri, 27 Feb 2015 12:29:52 GMT

Hi,

Can you post your complete expression which you are trying.

Regards

Gysbert_Wassenaar — Fri, 27 Feb 2015 12:30:40 GMT

Try count({<products={"=sum(sales)<sum(target)"}>}products)

Fri, 27 Feb 2015 12:31:55 GMT

i am using this exp;

=count({<products={'=sum(sales)<target'}>}products)

Fri, 27 Feb 2015 12:34:32 GMT

Hi Gysbert,

thanks for the reply,

it value showing '2',but it should be 1,because for region'c' is only not reached the target.

any help

Fri, 27 Feb 2015 12:36:24 GMT

sorry if i select products 'p1

Gysbert_Wassenaar — Fri, 27 Feb 2015 12:38:23 GMT

That's very interesting. It's showing 1 as result here based on the example data you posted.

timanshu — Fri, 27 Feb 2015 12:40:17 GMT

Hi Baru,

Can you elaborate your Query. As you said aggregation by region is giving count 0 . But this should give the count.

robert_mika — Fri, 27 Feb 2015 14:42:55 GMT

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