topic Re: I need help with Dynamic Sorting of dates in my equation in App Development

I need help with Dynamic Sorting of dates in my equation

Anonymous — Thu, 09 Aug 2018 04:49:25 GMT

I was able to get instructions on how to modify colors per group from this lovely link here:

https://community.qlik.com/docs/DOC-8492

I have created a Line graph using the link above and was able to successfully change the colors or each of my synthetic values.

The problem is when I select certain dates, I don't want to graph to change. I want the graph to show the entire date range.

I have put {1} into my equations, but I still can't get the graph to stay put.

I have used the same equation with a normal graph (i.e. not changing the colors) and had no problems with the time line not changing.

Is this just something that can't be helped due to the nature of the equations, or is there a work around for this?

My current equation is something like this:

=If(

ValueList('Company1','Company2','Company3')='Company1',

(sum(

{1<[Agent]={'*McDonalds*','*Burgerking*','*Wendys*'},

[Sales Person]={'Station Account','Branch Office','*UNKNOWN*'}

[GP (LC)])

-SUM(

{1<[Principal]={'*Burgerking*'},

[Sales Person]={'Station Account','Branch Office','*UNKNOWN*'},

[Agent]={'*McDonalds*'}

[GP (LC)])),

If(

ValueList('Company1','Company2','Company3')='Company 2',

(sum(

{1<[Agent]=-{'*MacDonalds*','*Burgerking*','*Wendys*'},

[Sales Person]={'Station Account','Branch Office','*UNKNOWN*'}

[GP (LC)])

+SUM(

{1<[Principal]={'*Burgerking*'},

[Sales Person]={'Station Account','Branch Office','*UNKNOWN*'},

[Agent]={'*McDonalds*'}

[GP (LC)])),

if(

ValueList('Company1','Company2','Company3')='Company3',

(sum(

{1<[Agent]={'*'},

[Sales Person]=-{'Station Account','Branch Office','*UNKNOWN*'}

[GP (LC)])),

)))

Hope that someone can help me figure this one out.

Best,

Matt

Re: I need help with Dynamic Sorting of dates in my equation

undergrinder — Thu, 09 Aug 2018 09:50:19 GMT

Hi Matthew,

I think this method is obsolete now.

Have you tried the master item's color yet?

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Colors/assigning-colors-to-master-items.htm

Re: I need help with Dynamic Sorting of dates in my equation

undergrinder — Thu, 09 Aug 2018 09:51:21 GMT

sorry, I post it at wrong thread

Re: I need help with Dynamic Sorting of dates in my equation

sunny_talwar — Thu, 09 Aug 2018 10:19:15 GMT

Would you be able to share your qvf to show the issue? Alternatively, use Island Table dimension instead of ValueList to do this?

Re: I need help with Dynamic Sorting of dates in my equation

Anonymous — Fri, 10 Aug 2018 00:05:17 GMT

Hi Gabor and Sunny,

Thanks for the suggestions.

I do not have access to master data or qvf. I am only working from Qlik Sense Cloud. I am just the guy at the bottom who has to make things work.

I figured that having access to the master color items would make things a lot easier.

That being said, is there a way I can add a {1} type expression/statement to stop the dates from changing when selected?

Thanks again

Best,
Matt