Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a line chart based on various project.The issue is to first show a single line of total by month,and as the Total line selected then the all projects line should be displayed. I am not able to understand how to do this.
Lets suppose I have following table
Project | Month | Value |
---|---|---|
P1 | Apr | 20 |
P2 | Apr | 30 |
P3 | Apr | 40 |
P1 | May | 10 |
P2 | May | 50 |
P3 | May | 20 |
P1 | Jun | 30 |
P2 | Jun | 50 |
P3 | Jun | 10 |
P1 | Jul | 20 |
P2 | Jul | 30 |
P3 | Jul | 30 |
And the ouput must following chart like
and as I select this total line following Chart should be display
please anyone have any idea share with me.
Thanks
Bhawna
Hi,
I am not sure that expression drill possible in qlikview.
But easiest way to acomplish your task is ,
You can create two chart
1 with total and
2 With detail
Place them on each other and using Property->Layout tab>show it conditionally.
For this you can create one text Object set appropriate action to it.
Place it on Legend showing in chart
and make it transparent so when user click on Total it will change the chart.
Hope It will help you to acheive your task.
Regards,
Thank you.. I will try
Is the attached qvw the kind of thing you are after ?
Thank you for your reply,but I dont have Total field,I have to calculate it,but as I used it as calculated dimension it wont show the entire month value,it will show only specific month value.
Its okay I got the solution by creating Two charts with a text object,and I have added this text object on the chart by adding action to navigate from chart1 to chart2 and it works fine.