Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
rlhardin
Creator
Creator

Set Analysis Help needed

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.

 

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

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. 

View solution in original post

1 Reply
sunny_talwar

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. 

View solution in original post