Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Set Analysis Help

Hello! I am having a problem with a set analysis. I need the sum where Arrangement={'Hourly'} but I also need to give the alternative to whatever is selected.

Basically I am trying to add {$<Arrangement={'Hourly'>} to Sum({1-$}WIP_Total_Fees).

Thank you!!!

8 Replies
sunny_talwar
Not applicable

Re: Set Analysis Help

Alternative to whatever is selected? Not sure I understand....

With regards to adding the set in there, try this:

Sum({1-$<Arrangement={'Hourly'}>} WIP_Total_Fees)

Not applicable

Re: Set Analysis Help

So there are filters and drill downs, and I need the alternative to what is selected by the filters/drills. I need the selected of Arrangement=Hourly to remain regardless.

sunny_talwar
Not applicable

Re: Set Analysis Help

May be this:

Sum({<Arrangement={'Hourly'}>} WIP_Total_Fees)

The above will filter based on all selections, except Arrangement which will always be Hourly

Not applicable

Re: Set Analysis Help

But I need the alternative of the selections

sunny_talwar
Not applicable

Re: Set Analysis Help

I got it....

May be this:

Sum({1-$<Arrangement -= {'Hourly'}>} WIP_Total_Fees)

Not applicable

Re: Set Analysis Help

I figured it out. Thanks!

sunny_talwar
Not applicable

Re: Set Analysis Help

What was it? Can you share with us?

Not applicable

Re: Set Analysis Help

Sure. It was more that I was thinking about it the wrong way. I just did

Sum({$<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)/Sum({1<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)

And it accomplished the same thing.

Thanks!