-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 24, 2017 3:55 AM (in response to Ankit Gupta)What's the object you're using?
Table? Kpi?
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 24, 2017 4:02 AM (in response to omar bensalem )It's a Text & Image
Where I am showing Variance % as a Measure.
-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 24, 2017 4:16 AM (in response to Ankit Gupta)I don't think It's possible to colour the measure by condition in a text and image object.
So, Here's what I would propose:
1) Use a KPI Object
2) As a measure : sum([Actual Spend])/(sum([AOP CapEx]+sum([AOP OpEx]))) and format it as %
3) in Colour, just add a limit which would be 1 in your case
4) For your description of the situation, instead of using text object, you can use the Title and subtitle of the KPI object to add a significant description.
It would come to sthing like this:
Hope this helps; if not, please tell me and we'll try to figure out another solution
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 24, 2017 5:32 AM (in response to omar bensalem )Actually what you saying is correct, but the reason I am using Text & Image object because I am adding multiple information into it and minimizing the KPI object sometimes didnt show the tittle and Sub-tittle. But Text and Image has no such limitation, so thinking if I apply color condition here only so it will be great.
-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 24, 2017 5:57 AM (in response to Ankit Gupta)Unfortunaterly, I don't think this is possible with the Text object of Qlik Sense:
You can use the Advanced Vizlib extension:
http://branch.qlik.com/#!/project/57881118637877f40865b5cc
But you have to use multiple objects and put them under each other :
For example,
Let's suppose I have Car Sales / Total Sales:
It would be something like this:
You can play with the Tooltip Text to show you colored variances (its position, appear on hover or click, It's size, conditional coloring etc...)
With hopes that this helps !
Omar,
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 24, 2017 6:28 AM (in response to omar bensalem )Thanks Omar for the help, looks its a limitation with this object.
On the other note , have you ever tried Gantt chart in Qlik Sense, I was watching a blog on Qlik Branch , but didnt understand what need to be done. If you know and can share how to start for that.
-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 24, 2017 6:38 AM (in response to Ankit Gupta)-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 24, 2017 6:46 AM (in response to omar bensalem )Yeah the same one you shared in the link:
Actually I want to create a Dashboard to show Patients Journey... E,G once Patient enrolled into a therapy S/he need to go from many stages before the medicines delivered to him. For E.G
Post Enrollment in a Therapy, he should go with Insurance Process (to understand whats the cost and how much insurance will pay), then some times his details in the form not completed so teams have to back and forth to complete those, like that there are 3-4 more steps.
What I want to show and tell from on Gantt chart:
Like in:
Row 1 : from Step 1 to Step 2 how many days it took and if its completed
Row 2: From Step 2 to Step 3 how many days it took and if its completed or not (Let say not)
Row 3: What will be the next Step and approximate days it took
.
.
.
and so on
If I am in Customer shoes and want to understand Post enrollment when I got the medicine and and in which stage I am so I can check.
Being a Support guy from a company stand point I want to analyze which is the most crucial stage of a process which takes more time
and questions like this.
Hope I am making sense here and not confusing.
Thx
Ankit
-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 24, 2017 6:57 AM (in response to Ankit Gupta)Can you provide sample data so I can see what I can do?
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 24, 2017 7:01 AM (in response to omar bensalem )Sure, let me prepare and share it with you.
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 28, 2017 1:03 AM (in response to omar bensalem )Hi Omar
Here is the situation I am talking about;
Situation: I have some patients data in attached excel sheet, Starting from Enrolling into a therapy to delivery of Medicines s/he need to pass certain obstacles or Events in a particular order:
- Referral Received
- Insurance Investigation
- Authorization from Insurance Org
- Financial Assistance
- Nurse Training
Every event we calling it as Service Request which have a Start Date and an End Date (In case that activity is completed).
Problem I am trying to solve
- I am looking for a chart that will show me Dates on the X axis, Activity on Y axis
- I need to show Bars starting from the event start date (like a Gantt chart, I have looked in Qlik Branch but didn’t understand what they talking about and how to implement). E.G.
my first Event Starts on 1-Jan-17 and Ends on 15-Jan-17
Second Event starts on 16-Jan-17 to 15-Feb17
So chart will show Bar 1 for activity one till 15-Jan-17, Bar 2 from 16-Jan-17 to 14-Feb-17 and so on
Thx
Ankit
-
Re: Need Help in Coloring Expression based on Rule
omar bensalem Mar 28, 2017 8:13 AM (in response to Ankit Gupta)Hi Ankit,
See the attached app made by our friend danansell42.
this is the extension he's using:
I think it can help in your quest !
-
timeline extension.qvf 176.0 K
-
Re: Need Help in Coloring Expression based on Rule
Ankit Gupta Mar 28, 2017 8:52 AM (in response to omar bensalem )Hi Oman,
Thanks for the guidance, I have solved this today , but got in a trap, this timeline chart should mush have Start and END dates to be there, if I am showing let say 3 Events on my chart , and 2 have Start - End Date and One have start Date and No End Date (as its not sure) , the chart is not turning up. Do you know how to handle this situation.
Thx
Ankit
-
Re: Need Help in Coloring Expression based on Rule
Daniel Ansell Mar 28, 2017 9:49 AM (in response to Ankit Gupta)Hi Ankit
I have already suggested a solution on your other post
-
-
-
-
-
-
-
-
-
-
-