topic Re: Check if dates fall in alternate state in QlikView

Check if dates fall in alternate state

Anonymous — Fri, 14 Mar 2014 15:03:34 GMT

I'm using a bar chart to show the volume of incidents created in alternate state A and B. I want to change the bar color if the date falls into A. Possible?

Re: Check if dates fall in alternate state

PrashantSangle — Fri, 14 Mar 2014 15:09:04 GMT

Hi,

It is possible

You can click on + sign of your expression you will see Background Color.

In that right expression like

if(fieldname='A',Red(),Green())

if(fieldname='A',RGB(125,125,125),RGB(255,255,255))

Re: Check if dates fall in alternate state

SunilChauhan — Fri, 14 Mar 2014 15:10:05 GMT

write in background of expression

if(state ='A' and isnull(Date)=-1,REd(),Green())

hope this helps

Re: Check if dates fall in alternate state

Anonymous — Fri, 14 Mar 2014 17:00:38 GMT

Neither worked.

I think Max's is checking to see if the field is equal to string value of.

Sunil - is state supposed to be a function or the state name?

Re: Check if dates fall in alternate state

jerem1234 — Fri, 14 Mar 2014 17:13:14 GMT

Could you elaborate a little more of your situation and explain the expressions/dimensions of your chart and maybe how you are using the alternate states. Not sure what you mean by "date falls into A".

Re: Check if dates fall in alternate state

Gysbert_Wassenaar — Fri, 14 Mar 2014 17:24:50 GMT

Maybe something like:

if( MyDate >= min({A}MyDate) and MyDate <= max({A}MyDate , blue(), red())

Re: Check if dates fall in alternate state

Anonymous — Fri, 14 Mar 2014 17:30:02 GMT

Sure can.

I have a bar chart in the inherited state w/ the following:

Dimension: WeekStart(Opened_At)

Expression: Count(Distinct {StateA} Incidents) + Count(Distinct {StateB} Incidents)

I have 2 separate list boxes with all the WeekStart(Opened_At) values, one in StateA and one in StateB. When a week is selected in each list box, the bar chart shows volumes for the days in those weeks. I want to change the bar colors based on the the week they fall in so the data appears separated and users know the bar falls into StateA vs StateB.

Before finishing this, I did just realize I can do a background color expression for checking the count. Using:

=if(Count(Distinct {StateA} Incidents)>0,red(),green())

Re: Check if dates fall in alternate state

SunilChauhan — Sat, 15 Mar 2014 15:12:07 GMT

its state Name field which should b e available in ur app.