topic Re: Change in text color expression in Qliksense in QlikView

Change in text color expression in Qliksense

nehapathak — Thu, 21 Dec 2017 11:17:16 GMT

Hi All,

I have attached a QVF file.

I Have a table with customers and count of employee id corresponding to those customers.

I have created a variable named max_date which basically calculate the maximum date from date field.

when the app is opened for the very first time then the data is displayed w.r.t. the max date i.e. Dec i.e nothing is selected from the date filter.

My requirement is that when the app is opened and data is displayed corresponding to max date i.e. December then my text color should be black.

when I select any date from date filter then my text color should changed as follows:

If current count of emplid > previous selected date count of emplid then Red.

If current count of emplid > previous selected date count of emplid then green.

Problem I m facing while using the expression I have created i.e.

if(GetSelectedCount(reportdate)=0,black(),

if(GetSelectedCount(reportdate)=1, if(count({$}Empid) > Count({$1}Empid),red(),Green() ))

)

is on first selection of date from date filter the current count of emplid is compared with the total count of all the dates and give color accordingly which is wrong.

For eg. if for first time I select October then count corresponding to October is being compared with the count of Dec, Nov, Oct.

What is want is that when on first selection I select October then the October count should be compared with max date i.e. max_date variable data and on next selection the current filter selection count should be compared with the previous selected filter date and should give colors accordingly.

Kindly Help.

Thanks In advance.

Re: Change in text color expression in Qliksense

pooja821 — Thu, 21 Dec 2017 12:36:19 GMT

stalwar1‌ Kindly help on this one..

Re: Change in text color expression in Qliksense

pooja821 — Thu, 21 Dec 2017 12:40:23 GMT

luismadriz‌ Kindly help on this one....please.

Re: Change in text color expression in Qliksense

divyanshi — Thu, 21 Dec 2017 12:46:10 GMT

shraddha.g‌ Kindly help...

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 12:48:46 GMT

Not entirely sure, but may be this

If(GetSelectedCount(reportdate) = 0, Black(), If(GetSelectedCount(reportdate) = 1, If(Count({$}Empid) > If(Count(TOTAL {$1}Empid) = 0, Count({<Date = {"$(=$(max_date))"}>} Empid), Count({$1}Empid)), Red(), Green())))

Re: Change in text color expression in Qliksense

nehapathak — Thu, 21 Dec 2017 12:57:51 GMT

on first selection it is showing all in green color but not comparing with the default max date

but for second selection onwards its working fine

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 13:00:35 GMT

My bad, try this

If(GetSelectedCount(reportdate) = 0, Black(), If(GetSelectedCount(reportdate) = 1, If(Count({$}Empid) > If(Count(TOTAL {$1}Empid) = 0, Count({<reportdate = {"$(=$(max_date))"}>} Empid), Count({$1}Empid)), Red(), Green())))

Re: Change in text color expression in Qliksense

pooja821 — Thu, 21 Dec 2017 15:51:15 GMT

its again comparing with total value but not with the default max value....thats why showing in all green colors..

We want is that when we select any value from report date filter for first time then as previous selected value was by default max date, then the current selected value should be compared with the previous date selected value(default max date)

Though after first selection the cycle is working fine..

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 16:19:02 GMT

I see the problem... the problem is not the expression, its the way Qlik Sense's selection works... To make a change in selection, you have to make two selections. First you deselect what is already selected and then you select what you want to (or the other way around). For some reasons, they are considered two selections. May be you want to go back two selections with $2 instead of $1

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 16:20:45 GMT

This

If(GetSelectedCount(reportdate) = 0, Black(), If(GetSelectedCount(reportdate) = 1, If(Count({$}Empid) > If(Count(TOTAL {$2}Empid) = 0, Count({<reportdate = {"$(=$(max_date))"}>} Empid), Count({$2}Empid)), Red(), Green())))

Re: Change in text color expression in Qliksense

pooja821 — Thu, 21 Dec 2017 17:10:17 GMT

Sorry to say but its still not working..

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 17:10:51 GMT

Have you checked the attached sample... I saw it working for me...

Re: Change in text color expression in Qliksense

sunny_talwar — Thu, 21 Dec 2017 17:18:06 GMT

Since the colors are barely noticeable, I have created a separate expression to show what color it should be showing...

When we open up

Next we select 10/31/2017

Next we select 11/30/2017

Also, added as a background color for better visibility

Re: Change in text color expression in Qliksense

pooja821 — Fri, 22 Dec 2017 04:23:16 GMT

Yes, I have checked.

Its still comparing with total value.

The thing is that on the first selection all the numbers are reducing which are less in comparison to the total value that's why the color has changed to green.

Unfortunately there is no case where the number has increased upon first selection, else you would have come to know about the problem.

Re: Change in text color expression in Qliksense

pooja821 — Fri, 22 Dec 2017 04:25:21 GMT

And also we are using Field UI extension with by default one selection at a time instead of filter pane.

Re: Change in text color expression in Qliksense

nehapathak — Fri, 22 Dec 2017 05:01:35 GMT

hi Sunny

Your app is working fine with normal filter pane but not with field UI extension (used for always one selected value)

When I am selecting specific customers from pivot table the colors are not changing correctly

but without any selection of customer its working fine.

Re: Change in text color expression in Qliksense

sunny_talwar — Fri, 22 Dec 2017 12:09:22 GMT

I don't have the extension, so I don't really know how it works. May be someone with the extension can help better

Re: Change in text color expression in Qliksense

sunny_talwar — Fri, 22 Dec 2017 12:12:04 GMT

I think the problem is not with the expressions that I have been offering, the issue has to do with the extension.... If you will continue to attack the wrong problem, you will get no where. I think what you need to do is to check how does $1, $2 behave with your selection in the extension filter object. Once you are able to figure that part out, the expression's logic itself will stay the same....

Does that make sense?