topic Re: exception elements in QlikView

exception elements

Fri, 25 Nov 2016 07:35:53 GMT

I would like to display the total products ( in group) in the table

For 1 situation -Product2

if i use filter Group, i have situation 2

we see Product2 and Product3 in table

Anonymous — Fri, 25 Nov 2016 07:45:37 GMT

do mean

Situation 1:

You want to see all groups A-D but only for product 2

Situation 2:

You want to see all groups A-D but only for product 2 & product 3

Anonymous — Fri, 25 Nov 2016 07:50:55 GMT

If so try these in your expressions:

Situation1:
sum({<Product = {'Product2'}>}Vol)

Situation2:
sum({<Product = {'Product2','Product3' }>}Vol)

Fri, 25 Nov 2016 08:11:47 GMT

it's too easy situations

For example I'm choosing the D and C in the filter

Fri, 25 Nov 2016 10:26:39 GMT

if( Count( Total <Product> Product)=Count(TOTAL DISTINCT Grooup) ,Sum( Vol),0)

It's my idea, but I look for another

Fri, 25 Nov 2016 11:17:42 GMT

Sum( {<Product = {'=aggr(count (distinct Grooup ),Product )=GetSelectedCount(Grooup)'} >} Vol)