Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is this possible in Qlikview?

Dear Community,

I want to know, Is this possible in qlikview?

I have a table like this:

CompanyProductSales Qty
AP120
BP121
CP125
AP225
BP223
CP212
AP426
BP437
CP412
AP515
BP514
CP523

Now I want to see in the graph Those companies Products which is performing well better than my company('A').Expected result like

AP120
BP121
CP125
AP426
BP437
CP412
AP515
BP514
CP523

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

1 Solution

Accepted Solutions
Not applicable
Author

Something like this?

View solution in original post

4 Replies
nizamsha
Specialist II
Specialist II

Try this one

u r excluding the p2 Product

sum({$<Product-={"P2"}>}salesQty)

Not applicable
Author

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.   

Not applicable
Author

Something like this?

Not applicable
Author

Thanks Darisuz.

Its working perfectly as per expectation.Thank you so much for your help.