Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Drill

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

ProjectMonthValue
P1Apr20
P2Apr30
P3Apr40
P1May10
P2May50
P3May20
P1Jun30
P2Jun50
P3Jun10
P1Jul20
P2Jul30
P3Jul30

And the ouput must following chart like1.png

and as I select this total line following Chart should be display

2.png

please anyone have any idea share with me.

Thanks

Bhawna

4 Replies
PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Thank you.. I will try

Anonymous
Not applicable
Author

Is the attached qvw the kind of thing you are after ?

Not applicable
Author

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.