topic Re: Data should not filter on date field in QlikView

Data should not filter on date field

Fri, 30 Oct 2015 06:04:08 GMT

Hi,

Below is my expression

=Count({1<U_Available_Status={"Not For Sale","Blocked","Available","Sold","Booked"},

FiscalYear=,FiscalQuarter=,FiscalMonth=,Week#=,[Day (#)]=,

P_Name=P(P_Name),B_Name=p(B_Name),T_Name=P(T_Name),Product_Name=p(Product_Name)>}DISTINCT U_ID)

I am trying to filter the count only with p_name not with FiscalYear,FiscalQuarter,FiscalMonth,Week# and [Day (#)].

Please check the expression.

Reagrds,

Keerthi KS

Re: Data should not filter on date field

jonathandienst — Fri, 30 Oct 2015 06:09:35 GMT

The overrides for FiscalYear to [Day (#)] are redundant as the 1 already ignores all selections. I assume your expression is not filtering the way you want, but its impossible to suggest useful alternatives without looking at your qvw or at least a representative sample.

Re: Data should not filter on date field

Fri, 30 Oct 2015 06:12:24 GMT

QVW is around 500mb.

Count of the U_ID should not be dependant on FiscalYear to [Day (#)]. Means if i select fiscalyear, count should not have any impact.

Re: Data should not filter on date field

jonathandienst — Fri, 30 Oct 2015 06:16:21 GMT

See here for how to prepare a sample document

Preparing examples for Upload - Reduction and Data Scrambling

Re: Data should not filter on date field

Fri, 30 Oct 2015 06:20:17 GMT

Count({$<U_Available_Status={"Blocked","Available","Sold","Booked","Not Available","Not for Sale"},FiscalYear=,FiscalQuarter=,FiscalMonth=,Week#=,[Day (#)]=>} U_ID)

This expression is working. Data will not filter on date fields.