How to show the Bar Chart values of the corresponding current date value only

[#1]

Hi

Want to have a Bar-Chart showing only the corredonding values of the most current day (despite of all selections and without detaching the chart of course)

I do have a table like this:

Critical	High	Low	Medium	Total	date5
66002	35486	13437	90714	1233739	25.09.2012 00:00:00
61751	35574	13364	89370	1279435	24.09.2012 00:00:00
61278	35624	13377	89109	1278986	23.09.2012 00:00:00
64200	35735	13376	88419	1279938	22.09.2012 00:00:00

Let's look on Bar Chart for column "Critical" only:

As an uxpression I used: =sum({<date5={$(vDateToday)}>} Critical)  // vDateToday is a variable containing the current Date

Result: Bar for Column "Critical"  is "0", Value of vDateToday "41177" i.e. (which is the Num Value for Sept, 25th 2012 00:00:00).

Expected Result: Bar Value  in Chart for Column "Critical" should be '66002'

How to tell Qlikview to compare [date5] Value "25.09.2012 00:00:00" to vDateToday Num Value "41177" to show the desired results?

Many Thanks for any idea how to get this done.

Joerg

[swuehl · Accepted solution]

Try formatting your set modifier according to your field format, maybe like

=sum({<date5={'$(=Timestamp(vDateToday))'}>} Critical)

[#3]

Hello swuehl.

Thanks for that quick help. Your answer is correct. Tried it already with "Timestamp" but did not get through with it.

Very Helpful.

Joerg