Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
silviacico
Partner - Contributor II
Partner - Contributor II

Barchart and dates

Hello,

I hope some of you experts may help me 🙂

I have a barchart with dimension: 

=if(month([Date of Event Reference])<month(Today()),
   [Date of Event Reference Year Month],
                 if(week([Date of Event Reference])<week(Today()),
                 WeekName([Date of Event Reference]),
                                          [Date of Event Reference]))

 

and it shows previous months, previous weeks of the current month and the days of the current week.

silviacico_0-1590500974236.png

I need to color the bars like this:

if(week([Date of Event Reference]) =week(today()), green(),
          if(month([Date of Event Reference]) = month(Today()) and week([Date of Event Reference]) <> week(today()), blue(),
                        if(num(month([Date of Event Reference])) < num(month(Today())), yellow())))

but it seems to work only the first statement: 

if(week([Date of Event Reference]) =week(today()), green()

 

Thank you very much, any advice and suggestions will be very appreciated

 

Labels (2)
0 Replies