topic Re: Ignore selection in QlikView

Ignore selection

Wed, 20 Nov 2013 13:50:28 GMT

Hi all

I have following issue:

the yellow field should be always disconnected to the selection that is currently done.

I managed to create the formula for the field "available SKU per Brand" but I couldn't find a solution to create it for Brand and CAT

Formula for Field "available SKU per Brand": count(all <Brand> distinct SKU)

hope you can help me...

thanks

Oliver

Re: Ignore selection

johanlindell — Wed, 20 Nov 2013 14:00:50 GMT

Hi,

Try count({1} distinct SKU).

You should though try to avoid distinct counts. In your SKU table add a column [Count SKUs] with 1 as value and use Sum({1} [Count SKUs]).

Re: Ignore selection

Wed, 20 Nov 2013 14:01:00 GMT

Olivier,

Use the set analysis, sth like

count({1} distinct SKU)

A document on Set Analysis: http://community.qlik.com/docs/DOC-4951

The same in French: http://community.qlik.com/docs/DOC-4889

Fabrice

Re: Ignore selection

hic — Wed, 20 Nov 2013 14:03:13 GMT

You should use set analysis, e.g. count({1} SKU). Further, the All qualifyer is obsolete and will some day be removed. You can use " {1} total " instead.

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope

HIC

Re: Ignore selection

Wed, 20 Nov 2013 14:42:35 GMT

Super cool - Thank you all!