Line chart drill view or interactive view

mayankraoka — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have to show the products sales over the period of time Assume suppose I have 20 products and on initial view ill show trend view line chart monthly sales.Now when I select the one product it should show 2 lines one is selected product line and other is other products sales.Is this possible to create line chart such like that?

Or else please let me know how I can show this in more interactive way.The main purpose is to compare the difference between selected product sales and remaining products and to compare over the period.

Please let me know in case of any questions.

Any help is highly appreciated.

Regards,

Mayank

Re: Line chart drill view or interactive view

sunny_talwar — Tue, 03 May 2016 21:06:47 GMT

You sure can. I have used Years instead of months in the attached application, but the idea should stay the same. You just need to use Month or MonthYear based on your requirement.

When Selected:

When not selected:

Expression 1) =Sum(Sales) -> No Condition

Expression 2) =Sum({1-<Product = P(Product)>}Sales) -> Show Hide Condition =GetSelectedCount(Product) > 0

topic Line chart drill view or interactive view in QlikView

Line chart drill view or interactive view

Re: Line chart drill view or interactive view