topic Re: Alternate state in QlikView

Alternate state

Nagaraju_KCS — Wed, 24 Feb 2016 13:09:50 GMT

HI Community,

Can we use Alternate state in Layout Condition..???

Suppose i have 2 Alternate Selections, If i am select 2 States i want to display 3 chart..

Is any possibility??

Thanks

Re: Alternate state

sunny_talwar — Wed, 24 Feb 2016 13:32:09 GMT

If you select 2 States? How are you planning on making a selection in Alternate State? Or do you mean to make selection in fields within different states? Please elaborate so that we can help you better

Re: Alternate state

Nagaraju_KCS — Wed, 24 Feb 2016 13:38:35 GMT

Exactly..

I have 2 different state selections..

if i am select these 2 states, i want to display 3 chart.. depends on these 2 state selections..

Hope you understand...

Re: Alternate state

sunny_talwar — Wed, 24 Feb 2016 13:39:36 GMT

How are you selecting states is my question? Can you share a sample where you doing this?

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:13:46 GMT

!Hi Sunny,

PFA,

Thanks

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 03:20:27 GMT

Try this condition:

(GetSelectedCount(DivisionName, False(), 'G1') + GetSelectedCount(Category, False(), 'G1') + GetSelectedCount(ProductName, False(), 'G1') > 0) and

(GetSelectedCount(DivisionName, False(), 'G2') + GetSelectedCount(Category, False(), 'G2') + GetSelectedCount(ProductName, False(), 'G2') > 0)

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:31:36 GMT

It's not working..

Expression showing Error

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 03:33:07 GMT

Have you looked at the attached qvw file? It isn't working for you?

Re: Alternate state

Saravanan_Desingh — Thu, 25 Feb 2016 03:34:03 GMT

I learnt something today. Elegant piece of code Sunny.

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:36:42 GMT

In Application also not working,

See attached Image..

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 03:37:54 GMT

What version of QV are you using? Is it anything before QV 11.2 SR8? If it is, then the above expression won't work.

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:44:37 GMT

I am using QV 11 version...

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 03:46:46 GMT

SR?

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:52:31 GMT

It showing Only Qlikview 11

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 03:55:42 GMT

You can check it in under Help -> About QlikView..

Regardless the point is, do you think you can update to the most recent version of QlikView? Because this expression will work in the recent versions of QlikView.

Re: Alternate state

Nagaraju_KCS — Thu, 25 Feb 2016 03:58:56 GMT

See this.. Should i update Qlikview???

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 04:07:03 GMT

Yes, I think you should definitely do an update because there are a lot of new functionality available in QV12. You are on SR7 and that is why my proposed expression isn't working for you.

Re: Alternate state

settu_periasamy — Thu, 25 Feb 2016 04:15:39 GMT

It's working for Me..

Version : 11.2 SR 9

Re: Alternate state

sunny_talwar — Thu, 25 Feb 2016 04:17:34 GMT

Thanks for the confirmation Settu‌

Re: Alternate state

settu_periasamy — Thu, 25 Feb 2016 04:36:19 GMT

I think, 11.2 SR7 doesn't have the third argument for 'GetSelectedCount()' .

Check the Below thread, swehul reply..

Alternate states with getfieldselections

And here

Conditional Hiding/Showing not working in Alter... | Qlik Community