topic Expression Drill in QlikView

Expression Drill

Sat, 26 Jul 2014 07:54:31 GMT

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

Re: Expression Drill

PrashantSangle — Sat, 26 Jul 2014 08:26:06 GMT

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,

Re: Expression Drill

Sat, 26 Jul 2014 09:42:52 GMT

Thank you.. I will try

Re: Re: Expression Drill

Anonymous — Sat, 26 Jul 2014 10:21:24 GMT

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

Re: Expression Drill

Mon, 28 Jul 2014 07:38:06 GMT

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.

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

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

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