topic Re: Alternate States with Set Analysis in QlikView

Alternate States with Set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I created and assigned "State 1" on one of my textbox objects. Within this object, I have set analysis: sum({$<[Receipt Type]={'Follow-up Receipt'}>} [Case Count]). But the result wasn't correct. How I can modify it?

Thanks,

Becky

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 13:33:04 GMT

But you also assigned your expression inherited state by adding the $ (dollar sign)... try this:

Sum({<[Receipt Type]={'Follow-up Receipt'}>} [Case Count])

Re: Alternate States with Set Analysis

Thu, 28 Jul 2016 13:37:47 GMT

Oh, got it.

I thought I should do =Sum({[State1]<[Receipt Type]='Follow-up Receipt'>} [Case Count]) ..

Thanks Sunny!

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 13:40:20 GMT

If you object is in State1, you don't have to specify it (you can, but you don't have to). But specifying $ is problematic, because then you are telling the expression to ignore object's state and react to inherited state

Re: Alternate States with Set Analysis

Thu, 28 Jul 2016 13:43:14 GMT

Oh, I see. Really helpful Sunny!

So I noticed one thing. I assigned "year" object and textbox objects in State1. So when I choose the year in my current tab, it won't effect the result in other tabs. However, there is no value shows up in the "Current Selections" box. Do you know why?

Btw, I am not sure why I can't find "correct" answer option...This is the first I cann't find it.

Best,

Becky

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 13:47:12 GMT

Well as long as you want your expression to be in the same state as your object, you don't need to add anything there. If you want the expression to behave to another state, or if you want it to be react to multiple states, then you need to specify the state.

Look here for marking correct and helpful responses:

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 13:50:34 GMT

Have you checked if you current selection box is in the same state as the state where you are making selection in the year field?

Re: Alternate States with Set Analysis

Thu, 28 Jul 2016 13:53:26 GMT

oh! That's why!! Thank you ha!

There is no "Correct Answer" button shows up. It only happened today. Very weird. I will try to log out and log in to see.

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 13:56:03 GMT

Could be the browser issue. Not entirely sure

Re: Alternate States with Set Analysis

Thu, 28 Jul 2016 14:01:41 GMT

I switched to another browser, but it shows the same. See the little icon in front of my post is different than others.

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 14:06:05 GMT

Oh I get it, this thread is opened as a discussion instead of a question. There is no way to revert back. Its fine if you leave it like this now

Re: Alternate States with Set Analysis

Thu, 28 Jul 2016 14:09:55 GMT

Oh, maybe I accidentally unmarked "mark as question". Sorry...And thank you again Sunny.

Re: Alternate States with Set Analysis

sunny_talwar — Thu, 28 Jul 2016 14:11:31 GMT

No problem at all, I am glad I was able to offer help