topic Re: Sales Today expression in App Development

Sales Today expression

Tue, 15 Aug 2017 10:44:01 GMT

Hello,

I've been trying to set an expression that locks my sales for today. But after going through these forums and youtube and guides I can't seem to get it to work.

What I need is todays sales numbers in the Business area "Stores" which is called Affärsområde.

This is what I got right now,

sum({<Date={'$(=Date(Today(),'DD/MM/YYYY'))'}, Affärsområde={'80 BUTIK'} >} TB)

TB = Sales

Affärsområde = All the stores we got

HEEEELP!

Re: Sales Today expression

techvarun — Wed, 16 Aug 2017 07:46:41 GMT

Try this

=Sum({<Date={'$(=Today())'}, Affärsområde={'80 BUTIK'} >} TB)

Re: Sales Today expression

arvind_patil — Wed, 16 Aug 2017 07:47:07 GMT

Hi Fredrik,

Kindly check your date format and try to like below:

sum({<Date={'$(=Date(Today(),'DD/MM/YYYY'))'}, Affärsområde={"80 BUTIK"} >} TB)

Thanks,

Arvind Patil

Re: Sales Today expression

Wed, 16 Aug 2017 08:39:39 GMT

How do I check my "date format"?

Re: Sales Today expression

antoniotiman — Wed, 16 Aug 2017 09:04:21 GMT

Hi Fredrik,

try this

sum({<Date={"$(=Date(Today(),'DD/MM/YYYY'))"}, Affärsområde={'80 BUTIK'} >} TB)

Regards,

Antonio

Re: Sales Today expression

Wed, 16 Aug 2017 09:31:44 GMT

I still get the whole year of sales somehow.

Re: Sales Today expression

sunny_talwar — Wed, 16 Aug 2017 11:55:39 GMT

Just like antoniotiman‌ pointed out, you need double quotes around the whole Date(Today(), ....) thing. The reason for this is because you have single quotes around your date format and single quotes around single quotes confuses QlikView into thinking that the starting single quote around your date format is the end of the first single quote.... to avoid this, you can use Escape sequences, but what Antonio has pointed out is a better option for you here.

Re: Sales Today expression

Wed, 16 Aug 2017 12:22:02 GMT

Well I tried what Antonio said and it still replied with the numbers for the "Year" and not todays sales.

Re: Sales Today expression

antoniotiman — Thu, 17 Aug 2017 08:42:35 GMT

Are You sure your Date field is formatting DD/MM/YYYY ?

Re: Sales Today expression

stabben23 — Thu, 17 Aug 2017 08:44:29 GMT

Hi Fredrik,

I dont know Your chart, but try Your Expression inside a pivot/straigt table.

Dont use a label on the Expression, just the Expression. Then hover over the header in chart, you will then see if you have correct dateformat. Test until you got correct format.

Re: Sales Today expression

sam_grounds — Thu, 17 Aug 2017 09:28:57 GMT

Go into your table viewer (CTRL + T) and right click on the table with your date and choose to "Preview" that will show a sample of your data, a quick glance at your date field should give you the info you need. Then you can use =date(today(),'DD/MM/YYYY') (or whatever format you want, you could do) =date(today(),'YYYY-MM-DD') if it's a SQL format date.

Re: Sales Today expression

sam_grounds — Thu, 17 Aug 2017 09:30:27 GMT

If your date has a time in it, use the floor() function to wrap around the date field to drop it to a flat date with a time of midnight.

Re: Sales Today expression

Thu, 17 Aug 2017 13:08:08 GMT

=date(today(),'YYYY-MM-DD') This gives me the correct date. But I can't figure out how to make this combined with todays sales. All the different tests I do give me either nothing or the month.

Re: Sales Today expression

sunny_talwar — Thu, 17 Aug 2017 13:11:30 GMT

Can you post a filter object with date as your dimension so that we can see its formatting

Re: Sales Today expression

Thu, 17 Aug 2017 13:15:27 GMT

Like this you mean?

Re: Sales Today expression

sunny_talwar — Thu, 17 Aug 2017 13:16:46 GMT

Your date format seems to be this: YYYYMMDD, try this

Sum({<Date={"$(=Date(Today(),'YYYYMMDD'))"}, Affärsområde={'80 BUTIK'} >} TB)

Re: Sales Today expression

Thu, 17 Aug 2017 13:20:49 GMT

Still appears with the whole "year" of sales. Can it be because "Date" is called "Datum" or what else could be the issue?

Re: Sales Today expression

sunny_talwar — Thu, 17 Aug 2017 13:23:51 GMT

Well, I assumed that your date field is called date... but yes, if it is called datum, then try this

Sum({<Datum={"$(=Date(Today(),'YYYYMMDD'))"}, Affärsområde={'80 BUTIK'} >} TB)