topic Re: Help with items that have the same value in QlikView

Help with items that have the same value

educastri83 — Sat, 16 Nov 2024 02:35:24 GMT

This time I need your help to identify when:
* in a mobile line there are more than one discount, which have the same discount value but with different revenue code.

Something like this case:

At least at this time I am not interested in cases when the discounts have the same value and revenue code.

I put the base files and the test qvw.

Thanks for your support.

Re: Help with items that have the same value

Frank_Hartmann — Mon, 02 Sep 2019 11:25:51 GMT

Is this what you are trying to achieve?

Backgroundcolorexpression:

=if(Aggr(NODISTINCT count(Revenue_code),phone_number) <> 1 and aggr(sum(Amount),phone_number,Revenue_code)=aggr(above(sum(Amount)),phone_number,Revenue_code), lightgray(),)

hope this helps

Re: Help with items that have the same value

Brett_Bleess — Tue, 10 Sep 2019 16:44:53 GMT

Eduardo, did Frank's post help you get things working as you wish? If so, please use the Accept as Solution button on his post to give him credit and let others know that it did work. If you are still having issues, please provide an update.

Regards,
Brett

Re: Help with items that have the same value

educastri83 — Sun, 15 Sep 2019 23:27:03 GMT

Thanks frank, almost.. but it can work for me.

How can I do so that only the table only shows the records where the background turns gray, that is, it does not bring the entire pivot chart, only for cases where the condition applies.

Re: Help with items that have the same value

Frank_Hartmann — Mon, 16 Sep 2019 08:54:06 GMT

see attached

hope this helps

Re: Help with items that have the same value

educastri83 — Wed, 18 Sep 2019 16:48:30 GMT

Thanks Frank! it works