Search This Blog

Friday, June 30, 2017

Qlikview set analysis , Between two values



=

//SUM({<FactAll.RSTrakingDaySEQ={$(vRS_TrackingDaySEQ)}  >} $(vMeasures01Value))
//SUM({<FactAll.RSTrakingDaySEQ={">=$(vRS_TrackingDaySEQ)<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))
SUM({<FactAll.RSTrakingDaySEQ={">=1<=$(vRS_TrackingDaySEQ)"}  >} $(vMeasures01Value))


ข้อห้ามมมม ห้ามมี Space ระหว่าง >= <= เด็ดขาด จะทำให้ผลลัพธ์ผิด
" " Space is cause to error result! Pls eliminate it from {}

No comments:

Post a Comment