Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Ignore selection

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

4 Replies
johanlindell
Contributor II

Re: Ignore selection

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]).

Not applicable

Re: Ignore selection

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

Employee
Employee

Re: Ignore selection

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

Not applicable

Re: Ignore selection

Super cool - Thank you all!

Community Browser