Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Plz help to solve this 'Nested aggr' (Count if)

Hi,

I have several merchants selling products.

I want to see how one specific merchant performs against the other offers.

I want to show this as:

32 of his products are cheaper then the (other) cheapest merchant

5 products are equal with the cheapest

41 products are more expensive then the cheapest price.

Thus I need the min(price) of the merchant, which is in the focus.

And the min(price) of the other merchants excluding the "focus-merchant".

I have those two minimums as:

min(ALL <product_id> { $ <calc_merchant = {"OWN_CLIENT_DATA_FLAG"}>} price)

min(ALL <product_id> { $ <calc_merchant -= {"OWN_CLIENT_DATA_FLAG"}>} price)

now i need to count:

count ( if ( minFocusMerch < minOther, 1 count for cheapest, 1 for more exp)

First problem:

How to get rid off the nested aggr.

Second problem:

How could I use the 3 conditions as 2. dimension for a bar-chart

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

It would be better to understand your problem if you share some data with us.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

I know.

I currently have no demo data to share.

only qvf above 30 MB with real data which is under NDA.