Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Do I need a Macro for this?

I have list of stores (40) in a list box. The document produces various charts (time trends) on the store level performances e.g. sales, complaints, returns, etc. So when i select a store, It will give me a line chart of sales in my sales chart and line chart of returns in my returns chart for that store. If i select multiple stores it will change the chart to aggregate performance of the selected stores. This works fine and useful. However, now I want to produce a Sales chart for example in such a way that when selecting multiple stores instead of aggregating the sales it will add individual expression for the selected stores. e.g if i select 4 stores in the list box it should show me 4 lines in the chart representing individual performance of the selected store. Is it possible? What do i need to use? set analysis? Macro? or something else? Let me know if you need more explanation.

1 Solution

Accepted Solutions
bgerchikov
Contributor III

Re: Do I need a Macro for this?

Samarth,

I think if you add store as a secondary dimesion in your chart you will be able to view 4 lines when you select 4 stores.

Hope it will help.

2 Replies
bgerchikov
Contributor III

Re: Do I need a Macro for this?

Samarth,

I think if you add store as a secondary dimesion in your chart you will be able to view 4 lines when you select 4 stores.

Hope it will help.

Highlighted
Not applicable

Re: Do I need a Macro for this?

That worked. Thanks a lot.