topic Re: Issue with where Function in QlikView

Issue with where Function

NavinReddy — Mon, 29 Aug 2016 10:13:11 GMT

Dear Experts,

Good Afternoon,

i tried to apply filter on script side dashboard to get only FACT IDs= 'ACTV' records.

when i written this function on script side all the expressions would displaying '0' values.

with out where function all expression working file. any other way to filter the data to get only ACTV records,

please suggest me.

please find the below sample app for reference

Many Thanks,

Niranjan

Re: Issue with where Function

sunny_talwar — Mon, 29 Aug 2016 10:15:59 GMT

Would you be able to share a file where you have not used Where statement? It seems to be working the way I would expect. May be there is no data when you only have ACTV?

Re: Issue with where Function

avinashelite — Mon, 29 Aug 2016 10:16:26 GMT

Did you check whether you the data for FACT IDs like ACTV ??

Currently I am using personal addition , could you please share the script and expression

Re: Issue with where Function

NavinReddy — Mon, 29 Aug 2016 10:25:57 GMT

Hi Avinash,

Thanks for your reply, here is the expression im using

=Count(DISTINCT{<Month=, MonthYear={">=$(=date(MonthStart($(vMonth),-2),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}FCT_SETUP_ID)&

' '&'('&

num(num(Count(DISTINCT{<Month=, MonthYear={">=$(=date(MonthStart(max(MonthYear),-2),'MMM YY'))<=$(=Date(max(MonthYear),'MMM YY'))"}>}RAG_RATING_CD)/

Count(DISTINCT{<MonthYear=, MonthYear={">=$(=date(MonthStart(max(MonthYear),-2),'MMM YY'))<=$(=Date(max(MonthYear),'MMM YY'))"}>}Total <MonthYear>RAG_RATING_CD)),'###%')&')'

Many Thanks,

Niranjan

Re: Issue with where Function

NavinReddy — Mon, 29 Aug 2016 10:28:51 GMT

Hi Sunny,

Thank you for your reply,

please find the another QVW, with where condition working as expected.

Many Thanks,

Niranjan

Re: Issue with where Function

sunny_talwar — Mon, 29 Aug 2016 10:41:52 GMT

I think the issue is with you MonthYear field here. Its somehow not read correctly in your qvw where you have used the where statement. I changed the format from the numbers tab on document properties and everything started working again.

You can also do this in the script:

Date(MonthYear, 'MMM YY') as MonthYear

Re: Issue with where Function

NavinReddy — Mon, 29 Aug 2016 10:57:37 GMT

Hi Sunny,

Excellent Answer Thank You very much its working for me.

Many thanks,

Niranjan