Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]).
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
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
Super cool - Thank you all!