Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write a expression which counts for a particular day,
for eg. count(sales) , in which i need a include a where condition as date like count(sales) where date = 'today' or date = 'quarter to date"
I need to know the syntax for the same.
Help required on a urgent basis.
celambarasan,
count({$<dt-={'03/28/2012'}>} SURGEON) , even this gives the total count. my dt field in database is in varchar format, is that creating a problem to us?
Still i use a distinct function, it gives only the total count and not for the particular date
Hi,
Yes.you have to format the date while loading the table from the database.like Date(Date#(Field,Format))
Format is in what format the field in database has may be like 'DD/MM/YYYY'
Celambarasan
hi,
I use a sql statement like select * from table1;
now how to include the above said statement? either in sql format or i need to follow the syntax as qlik view format.
Hi,
Yes you can apply precede load to it like
Load
Field1,
Field2,
Date(Date#(Field,Format)) as dateField;
select * from table1;
Celambarasan
super cool!!!awesome!!! it works.