Date/Time group w/ dimension for current time minus 24 hours

[Anonymous]

I am relatively new to Qlikview.  I have been using Qlikview Personal for about 4 months on and off and just recently started diving further in.  Here's my deal, I have a data set containing all sales for a company over the last 6 months.  I set up a group containing a month and weekstart expression in order to toggle between the two and show the bar chart in Month time frames or Week time frames.  Now I am attempting to add an expression to the group set that returns sales for just the previous day and I am stumped

My field name for date = opened_at

[#2]

If you use Start functions like MonthStart, Weekstart etc.. Qlikview still takes the uniqe date&time for the expression. I could help you more if you show me an exemple but as far as i understood you can get what your want by using Week() function instead of Weekstart().

Best.

[Anonymous]

I am using the following

For Month grouping:  =Date(MonthStart(opened_at),'MMM-YY')

For Week Grouping:  =WeekStart(opened_at)

Those are working great.  Now I am trying to add an expression to the group that shows just sales yesterday but more specifically (if possible) sales >= current time - 24 hours.

[Anonymous]

completely my fault on the explanation.  I want to add a field to my dimension group for yesterday

[#5]

Hi,

You can try this in your dimension:

Date(now()-1,'DD/MM/YYYY')

This will reduce a day to the actual date.

Regards.