Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Show/hide cyclic group

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

8 Replies
Highlighted
MVP
MVP

Re: Show/hide cyclic group

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

Highlighted
Partner
Partner

Re: Show/hide cyclic group

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

Highlighted
MVP
MVP

Re: Show/hide cyclic group

use this..

Highlighted
MVP & Luminary
MVP & Luminary

Re: Show/hide cyclic group

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.

Highlighted
Partner
Partner

Re: Show/hide cyclic group

Still it doesn't work for Stock

Highlighted
MVP
MVP

Re: Show/hide cyclic group

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

Highlighted
Partner
Partner

Re: Show/hide cyclic group

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

Highlighted
Partner
Partner

Re: Show/hide cyclic group

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."