topic QlikSense Where Condition Problem in QlikView https://community.qlik.com/t5/QlikView/QlikSense-Where-Condition-Problem/m-p/1027227#M347053 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have this calculated dimension:</P><P></P><P>(if(len(CloseDate__c)=0, date(UnofficialCloseDate__c,'YYYY-MM-DD'),date( CloseDate__c,'YYYY-MM-DD'))) as date_fiscal_year</P><P></P><P></P><P>I need to insert it in the where conditon between two time ranges in the load script and&nbsp; I don't know how they work together.</P><P>How can I fix the problem?</P><P>Thanks a lot.</P><P>Bye bye</P></BODY></HTML> Thu, 25 Feb 2016 11:38:53 GMT 2016-02-25T11:38:53Z QlikSense Where Condition Problem https://community.qlik.com/t5/QlikView/QlikSense-Where-Condition-Problem/m-p/1027227#M347053 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have this calculated dimension:</P><P></P><P>(if(len(CloseDate__c)=0, date(UnofficialCloseDate__c,'YYYY-MM-DD'),date( CloseDate__c,'YYYY-MM-DD'))) as date_fiscal_year</P><P></P><P></P><P>I need to insert it in the where conditon between two time ranges in the load script and&nbsp; I don't know how they work together.</P><P>How can I fix the problem?</P><P>Thanks a lot.</P><P>Bye bye</P></BODY></HTML> Thu, 25 Feb 2016 11:38:53 GMT https://community.qlik.com/t5/QlikView/QlikSense-Where-Condition-Problem/m-p/1027227#M347053 2016-02-25T11:38:53Z