Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mugdhaojha
New Contributor II

Create a group in expressions for a line chart

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?New.png

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

1 Solution

Accepted Solutions
greeshma_k
Contributor III

Re: Create a group in expressions for a line chart

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

View solution in original post

10 Replies

Re: Create a group in expressions for a line chart

Could you attached your app?

jyothish8807
Honored Contributor II

Re: Create a group in expressions for a line chart

Hi Mugdha,

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

Regards

KC

Best Regards,
KC
mugdhaojha
New Contributor II

Re: Create a group in expressions for a line chart

Hi,

I have added a word document explaining my requirement.

Hope that helps.

mugdhaojha
New Contributor II

Re: Create a group in expressions for a line chart

Can someone help me on this?

mugdhaojha
New Contributor II

Re: Create a group in expressions for a line chart

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.

GroupExp.png

GroupExp2.png

jyothish8807
Honored Contributor II

Re: Create a group in expressions for a line chart

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

Regards

KC

Best Regards,
KC
mugdhaojha
New Contributor II

Re: Create a group in expressions for a line chart

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.

greeshma_k
Contributor III

Re: Create a group in expressions for a line chart

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

View solution in original post

mugdhaojha
New Contributor II

Re: Create a group in expressions for a line chart

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