Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

datanibbler
Esteemed Contributor

Multi-diagram - how to make a formula to not be displayed for (TODAY)?


Hi,

I have a multi-diagram with a quota that's represented by a line. The tricky thing is, there is no current data for (TODAY), so the quota seems to be 100% for today, but it isn't...

Is there any way to make the formula to be displayed only up to (Yesterday)?

I don't want to mess with the dimensions - there should be six days displayed from Monday on, with or without data. Making the background_color WHITE() is not a solution, either as that would cut right through the columns and would look a bit weird.

Can anyone give me a hint on how to do this?

Thanks a lot!

Best regards,

1 Solution

Accepted Solutions
MVP
MVP

Re: Multi-diagram - how to make a formula to not be displayed for (TODAY)?

Hi

Add a condition to the expressions to exclude today. Something like this:

     Sum({<Date -= {"$(=Today())"}>} Sales)

(assuming your date field is called Date and is a date only (now time portion) and is formatted in your models default date format)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Multi-diagram - how to make a formula to not be displayed for (TODAY)?

Hi

Add a condition to the expressions to exclude today. Something like this:

     Sum({<Date -= {"$(=Today())"}>} Sales)

(assuming your date field is called Date and is a date only (now time portion) and is formatted in your models default date format)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
datanibbler
Esteemed Contributor

Re: Multi-diagram - how to make a formula to not be displayed for (TODAY)?

Hi Jonathan,

many thanks!

Community Browser