Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

select date range

Hi all,

I have data before 11-30-2014, but i need to select data after that date so i am using below expression.

It,s not working please help on it.

Let vEnovaMinDate = 11-30-2014   {initializing variable }

count({<DateType = {invitation}, CanonicalDate = {">=$(date(=vEnovaMinDate))<=$(=max(date(CanonicalDate)))"}>}invitation_id)

can anyone help where i am going wrong

Regards,

Pramod

4 Replies

Re: select date range

Try

Count(

     {<

          DateType = {'invitation'},

          CononicalDate = {">=$(=Date(Date#(Min(vEnovaMinDate)),'MM-DD-YYYY'))<=$(=Date(Date#(Max(vEnovaMinDate)),'MM-DD-YYYY'))"}

     >}

invitation_id)

Not applicable

Re: select date range

always format date inside the variable, don't use any function directly in set analysis. After that,

CononicalDate = {">=$(vEnovaMinDate) <=$(vEnovaMaxDate)"} should work.


Important: Don't forget the white space between two variables.

Not applicable

Re: select date range

I am using like below it's wrong?

CanonicalDate = {">=$(=vEnovaMinDate) <=$(=date(today()))"}

because i need count till today from the start date.

But above is not working.

Not applicable

Re: select date range

wrong:  $(=vEnovaMinDate)

right:  $(vEnovaMinDate)


vEnovaMinDate variable must start with equal sign.