Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

hi made some changes to your model

have a look at the expression

View solution in original post

2 Replies
Highlighted
Master II
Master II

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

Highlighted
Partner
Partner

hi made some changes to your model

have a look at the expression

View solution in original post