topic Re: Show/hide cyclic group in QlikView

Show/hide cyclic group

NareshGuntur — Thu, 24 Mar 2016 07:54:12 GMT

Hi Guys,

I have a Block chart with two Cyclic groups conditionally enabled so that only one will be enabled based on a condition.

To my surprise, if the expression returns no value, both the Groups are coming up.

If it has data, it works fine.

It also works as expected for other charts.

Cheers,

Naresh

Re: Show/hide cyclic group

MK_QSL — Thu, 24 Mar 2016 07:58:12 GMT

Change the condition in dimension tab

For New Group

GetFieldSelections(Test)=1

For New Group1

GetFieldSelections(Test)=2

Also in your example there is no value for Stock... You can change to Sum(Sales) as an expression

Re: Show/hide cyclic group

NareshGuntur — Thu, 24 Mar 2016 08:01:43 GMT

Thanks Manish.

Issue occurs only when there is no value.

If I change it to Sum(Sales), there's no issue.

And it doesn't work even when GetFieldSelections(Test)=1 or 2

Cheers,

Naresh

Re: Show/hide cyclic group

MK_QSL — Thu, 24 Mar 2016 08:09:36 GMT

use this..

Re: Show/hide cyclic group

jagan — Thu, 24 Mar 2016 08:30:54 GMT

Hi Naresh,

I think it is a bug, the workaround is place text object on top of the cyclic groups and show/hide the text object conditionally.

Regards,

Jagan.

Re: Show/hide cyclic group

NareshGuntur — Thu, 24 Mar 2016 09:44:10 GMT

Still it doesn't work for Stock

Re: Show/hide cyclic group

MK_QSL — Thu, 24 Mar 2016 09:49:54 GMT

It will not work if you don't have any values... because in block chart you don't have option of Suppress Zero Values..

Re: Show/hide cyclic group

Gabriel — Thu, 24 Mar 2016 10:43:42 GMT

Hi,

Looking at your attached file. Your script don't have value for Stocks, populate Stocks in the script reload and your expression will work. With the Enable Conditions (Dimensions) for value in Field Test, use this

if(GetFieldSelections(Test)=1,1,0) // For Test = 1

if(GetFieldSelections(Test)=2,1,0) // For Test = 2

This should get you what you want.

Find attached

Re: Show/hide cyclic group

NareshGuntur — Thu, 24 Mar 2016 11:27:25 GMT

Hi Gabriel,

That's where I started. My Stock has no value and only then this issue arises. For example, there is no stock and so I can't populate stock.

My very first question says

" To my surprise, if the expression returns no value, both the Groups are coming up."