topic Re: Issue with an expression in QlikView

Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 06:48:52 GMT

Hello Everyone,

I have a requirement , in which I want to show a table with a range of date From and To . Here I am facing issue how to get a true condition i an expression if(Log_Date>$(MaxDate),1,0) . PFA with a sample.

Thank you

Regards

Ferha Sharma

Re: Issue with an expression

pradosh_thakur — Wed, 11 Oct 2017 06:58:48 GMT

can you be a little more specific with your requirement.

regards

Pradosh

Re: Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 07:03:21 GMT

I have a requirement in which I was to pass from date from calendar and to date from calendar and want to display Log date in between from and to dates.

Re: Issue with an expression

pradosh_thakur — Wed, 11 Oct 2017 07:17:51 GMT

pfa . is this what you are looking for?

regards

Pradosh

Re: Issue with an expression

petter — Wed, 11 Oct 2017 07:28:55 GMT

You should avoid formatted dates when doing logic. It is much better and safer to use the numerical version of the date.

For instance in you application you have:

If( Concat(Log_Date) <= $(vMaxDate) , 1 , 0 )

The Concat() function will concatenate as strings the formatted dates that are selected or possible so you get something like this as a result:

02/10/201703/10/201704/10/201705/10/201706/10/2017

This will be interpreted as a calculation consisting of many divisions and the result is:

5.9904817301955e-30

Similarly the $(vMaxDate) will be this if 04/10/217 is selected and that evaluates to this:

0.00019831432821021

And clearly this is not your intention - is it?

To get what you want you will have to do something like this:

If( Max(Log_Date) <= Num( $(vMaxDate ) ) , 1 , 0 )

Re: Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 07:35:59 GMT

Hello Pradosh,

Thank for your reply, I need it in a chart as a calculated dimension. Please check when I am using it in a table I am getting false condition.

Thank you

Re: Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 07:38:54 GMT

I want the dates between Min and Max as If(log_date <=vMaxDate

and log_date <=vMaxDate,log_date)

Re: Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 07:39:43 GMT

Please find attachment.

Re: Issue with an expression

pradosh_thakur — Wed, 11 Oct 2017 07:48:38 GMT

check this out

regards

Pradosh

Re: Issue with an expression

ferha_jafri — Wed, 11 Oct 2017 07:59:35 GMT

I used Log_Date={">=$(vFromDate)<=$(vToDate)"} in the expression.