Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I want to know, Is this possible in qlikview?
I have a table like this:
| Company | Product | Sales Qty |
| A | P1 | 20 |
| B | P1 | 21 |
| C | P1 | 25 |
| A | P2 | 25 |
| B | P2 | 23 |
| C | P2 | 12 |
| A | P4 | 26 |
| B | P4 | 37 |
| C | P4 | 12 |
| A | P5 | 15 |
| B | P5 | 14 |
| C | P5 | 23 |
Now I want to see in the graph Those companies Products which is performing well better than my company('A').Expected result like
| A | P1 | 20 |
| B | P1 | 21 |
| C | P1 | 25 |
| A | P4 | 26 |
| B | P4 | 37 |
| C | P4 | 12 |
| A | P5 | 15 |
| B | P5 | 14 |
| C | P5 | 23 |
Here How can I exclude those products which is performing will respect to others company.
Logic behind to ignoring P2
Sales Quantity for Company 'A' for product( P2) is grater than other companies product( 'P2').
Any thought or Solution is highly appreciate ...........
Thanks for advance helps.
Thanks and Regards
Sovan
Something like this?
Try this one
u r excluding the p2 Product
sum({$<Product-={"P2"}>}salesQty)
Thanks Nizam for your replay.
Here I want to find out those Products is performing well compare to my company product in a dynamic way.Those are considerable in this analysis.
Something like this?
Thanks Darisuz.
Its working perfectly as per expectation.Thank you so much for your help.