Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Does anyone have a suggestion on how can I go on and select/filter specific parts of data in my different charts? As I have lots of charts I have different requirements for each of those chart and need to select specific data to be shown in chart.
Its exactly like you have different filters in Microsoft Excel and it shows you in the pivot table but want to replicate that in Qlikview. So it then doesn't matter if I clear the selection in other tabs in Qlikview but chart still shows selected data. As for some of the charts I have 8 different selections to be made which can then show me that data in chart. It would be appreciated if anyone can share a suggestion.
Due to confidentiality example has not been shown but can clarify further based on your question. Thanks.
1) Since there are number of charts, How many are there should be static for each
2) Resolution may be using {1} in analysis of expression
3) May be create as many table using resident with different fields which can be modify / you can even try with Qualify or UnQualify
Thank you Anil, for your response.
1) Since there are number of charts, How many are there should be static for each
2) Resolution may be using {1} in analysis of expression
3) May be create as many table using resident with different fields which can be modify / you can even try with Qualify or UnQualify
Thank you.
You may share sample with dummy data and explain which sheet you want and what you need?
Hi there,
Thanks for your response Anil. Please see attached.
This is just dummy data. However, what I am trying to do is that there is Service and Continent Lane which I have not selected but I want to write a formula in Combo Chart which only shows me lets say Door to Door as service level and Asia-Africa as Continent Lane for Combo Chart 1 but for Pie Chart Iets say Port to Port as service level and Asia-Asia as Continent Lane. Additionally, Combo Chart and Pie chart should interact together but based on their individual formulas.
Also, once I reload my file it then updates the chart according to the formulas which has been written either in Dimensions or Expression for those specific chart but not sure how can I go on about doing it.
I also approached as IF formula like IF([Service]='Door to Door',[Service],Null()) but it doesn't bring back results and on that I have another field which is Continent Lane to be filtered. Would appreciate if anyone would have suggestions. Thank you.