Filtering

[MIST9AN]

Hi I imagine it is a bit basic question but I can't figure it out.

To simplify I have column with boxes. Red Box / White Box / Green Box

Each box has like a number of apples, pears, plums and strawberries.

I want to count only apples and pears from Red Box

only Plums from White

And all off them from Green

I want to have in the end value number of fruits per box but I want to count different kinds of fruit in each box.

Thanks!

How can I do it qlik sense

[RafaelBarrios]

Hi @MIST9AN 

Try

I want to count only apples and pears from Red Box

sum({< box_column_name={'Red Box'}, product_column={'apples','pears'} >} quantity_field)

or

sum({< box_column_name={'Red Box'}, product_column={'apples'} > + < box_column_name={'Red Box'}, product_column={'pears'} >} quantity_field)

only Plums from White

sum({< box_column_name={'White Box'}, product_column={'Plumns'} >} quantity_field)

And all off them from Green

sum({< box_column_name={'Green Box'} >} quantity_field)

Hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

[PrashantSangle · Accepted solution]

Yes . Using set analysis it easily possible.

Red Box = Sum({<Box={'Red'},Product={'Apple','Pears'}>}number)

White Box = Sum({<Box={'White'},Product={'Plums'}>}number)

Green Box = Sum({<Box={'Green'}>}number)

Regards,

Prashant Sangle