Set Analysis Help needed

Anonymous — Sat, 16 Nov 2024 03:30:24 GMT

I am working on a dashboard i inhabited from a former employee. it currently uses a month selection, however if you select multiple months the values all move to 0, a majority of calculations are like the one below

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops PdNo] = {'$(#=Only(_MM))'}>} [Revenue-Actual])

I am not sure how to change this so that I can select multiple at a time, i tried the formula below but still my values all changed to 0

sum ( {$<[Ops Year] = {$(#=Only(_YYYY))}, [Ops Month] = {"<=$(#=Only(_MM))"}>} [Revenue-Actual])

Can someone help me so I am able to select say multiple period at once. I have attached screen shots in the document attached.

Re: Set Analysis Help needed

sunny_talwar — Wed, 22 May 2019 17:38:32 GMT

If that is what you want, why do you even need set analysis... try this

Sum([Revenue-Actual])

This will show you the Sum of whatever is selected.

topic Set Analysis Help needed in QlikView

Set Analysis Help needed

Re: Set Analysis Help needed