topic Re: Current date Sales only in a straight chart in QlikView

Current date Sales only in a straight chart

geogou1973 — Fri, 04 Oct 2013 09:33:08 GMT

Hello,

I have in the inline table the fields DATE, STORE, SALES,

also i have created a variable with the current date.

How can i have in a straight chart the sales of the store only

for the current date without selecting from the listbox.

Thank you in advance

v_iyyappan — Fri, 04 Oct 2013 09:38:06 GMT

Hi,

Try like this,

Created the variable :

vCurrentDate = Date(Today());

=Sum({<Date={'$(=vCurrentDate)'}>}Sales)

Regards,

tresB — Fri, 04 Oct 2013 09:38:56 GMT

Take STORE as dimension, write expression like:

=Sum(If(Date=Today(), SALES)) // you might have to be careful about the date format.

geogou1973 — Fri, 04 Oct 2013 09:51:57 GMT

It works.

Thank you very much.