topic Re: Set analysis for from to date filter not working help required. in QlikView

Set analysis for from to date filter not working help required.

Mon, 01 Dec 2014 07:35:50 GMT

I'm getting list of breakdown equipment which is start date is AUSVN and End date is AUSBS field. I want to get list of equipment for the month select with variable and using set analysis. I've used following formula.

=Count({1<AUSVN = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {1<AUSBS = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {$<Plant= {$(vWERKS)} >}distinct EQUNR_V)

/Count({1<AUSVN = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {1<AUSBS = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {$<Plant= {$(vWERKS)} >}QMNUM)

where EQUNR_v is equipment and QMNUm is note no.

Find attached sample.

Thanks

Ashif

Re: Set analysis for from to date filter not working help required.

sushil353 — Mon, 01 Dec 2014 07:40:40 GMT

Hi Try below Expression:

=Count({1<AUSVN = {">=$(vMalFunStDT) <=$(vMalFunStDT)"},AUSBS = {">=$(vMalFunStDT) <=$(vMalFunStDT)"},Plant = {'$(vWERKS)'}> Distinct EQUNR_V}/ Count({1<AUSVN = {">=$(vMalFunStDT) <=$(vMalFunStDT"},AUSBS = {">=$(vMalFunStDT) <= $(vMalFunStDT)"},Plant = {'$(vWERDS)'}>} Distinct QMNUM)

HTH

Sushil

Re: Set analysis for from to date filter not working help required.

lironbaram — Mon, 01 Dec 2014 07:52:29 GMT

hi made some changes to your model

have a look at the expression