topic Re: Create a group in expressions for a line chart in QlikView

Create a group in expressions for a line chart

mugdhaojha — Wed, 20 May 2015 11:55:35 GMT

Hi,

I have requirement where I need to create a line chart which will show the percentage of Met SLA month & year wise and when I drilldown I should be able to see the Met SLA priority wise (i.e P1,P2...P4) .

Is there a way I can group the Met SLA and Compliance Priority wise?

Message was edited by: Mugdha Ojha Added a word document explaining what is my requirement.

Re: Create a group in expressions for a line chart

robert_mika — Wed, 20 May 2015 12:11:00 GMT

Could you attached your app?

Re: Create a group in expressions for a line chart

jyothish8807 — Wed, 20 May 2015 12:11:26 GMT

Hi Mugdha,

Can you explain a bit more and a sample app will be helpful to understand your requirement more.

Regards

Re: Create a group in expressions for a line chart

mugdhaojha — Thu, 21 May 2015 05:13:01 GMT

Hi,

I have added a word document explaining my requirement.

Hope that helps.

Re: Create a group in expressions for a line chart

mugdhaojha — Fri, 22 May 2015 05:03:30 GMT

Can someone help me on this?

Re: Create a group in expressions for a line chart

mugdhaojha — Fri, 22 May 2015 08:16:52 GMT

I managed to create the groups.

But I am facing the below issue :

For the Met SLA group I have used expression and I am getting Error in calculated dimension as the legend.

Is there a way I can hide this legend as the line graph is correctly plotted.

Re: Create a group in expressions for a line chart

jyothish8807 — Fri, 22 May 2015 08:24:58 GMT

Did you try to give a label to the Expression? Over you can hide the legends from Presentation Tab.

Regards

Re: Create a group in expressions for a line chart

mugdhaojha — Fri, 22 May 2015 08:42:01 GMT

I gave a label to the expression and tried hiding legends from Presentation tab but the cyclic group also disappears.

I have attached the app in the main post.

Re: Create a group in expressions for a line chart

Anonymous — Fri, 22 May 2015 12:24:01 GMT

Hi,

Another alternative could be to add an image of the cyclic group and add an action on it to set a variable. Using this variable you can show the Priority. Please see attached.

Regards,

Greeshma

Re: Create a group in expressions for a line chart

mugdhaojha — Mon, 25 May 2015 05:53:51 GMT

Thanks a lot..This is what I wanted!!

Re: Create a group in expressions for a line chart

cspindley — Mon, 14 May 2018 09:54:21 GMT

sorry a bit late ....

wot i do is to use a dimension group using the same filed but with a different label, that way i can get control of IT

hope that helps U