topic Re: Identifier in Set Analysis in QlikView

Identifier in Set Analysis

nigel987 — Mon, 23 May 2016 10:11:20 GMT

Hi, I am using following set analysis to count contracts:

='Contracts: ' & (Count({1<

Status={'Active'},

ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}

>}Distinct OrganisationID))

I want to ignore user-selections, therefore I used the identifier 1, but I think this does not work for the part:

ContractEndDate={"=ContractEndDate>=Date(MonthsStart(1,Today(),1)) and ContractEndDate<=Date(MonthsEnd(1,Today(),1))"}

I tried to insert the identifier 1 into this part as well, but I couldn't get the syntax right.

Does anyone know how to write it correctly?

Thanks,

Nigel

swuehl — Mon, 23 May 2016 10:13:48 GMT

Try

ContractEndDate={"=Only({1}ContractEndDate)>=Date(MonthsStart(1,Today(),1)) and Only({1}ContractEndDate)<=Date(MonthsEnd(1,Today(),1))"}

edit:

or:

ContractEndDate={">=$(=Date(MonthsStart(1,Today(),1)))<=$(=Date(MonthsEnd(1,Today(),1)))"}

nigel987 — Mon, 23 May 2016 10:17:00 GMT

Great! That's it. Thanks for the reply swuehl!