topic Problem with Show conditional in QlikView

Problem with Show conditional

Anonymous — Wed, 17 Dec 2014 18:14:48 GMT

I'm trying to hide a chart when I select x values, so I wrote a condition but doesn't work.

I get tired of change my code one and other time and I coded in the conditional "0 = 1" but didn't work too. What can it be?

Best regards,

Leandro

Re: Problem with Show conditional

german_avanzato — Wed, 17 Dec 2014 19:28:33 GMT

Do you have a example of the application?

Try the basic to be sure: put a 0 or 1 in the condition field, to try hide/unhide the chart.

Re: Problem with Show conditional

maxgro — Wed, 17 Dec 2014 19:37:45 GMT

in layout tab of your chart, conditional (x=2)

GetSelectedCount(yourfield)<>2

Re: Problem with Show conditional

Anonymous — Wed, 17 Dec 2014 19:38:35 GMT

Hi,

you can use this expression in the chart show condition

GetSelectedCount(Name_of_field)=0

KR.

Re: Problem with Show conditional

Gysbert_Wassenaar — Wed, 17 Dec 2014 19:39:52 GMT

You are talking about hiding the chart itself, right? On the Layout tab of the properties window is where you find the Conditional option for that. If you use 0=1 as expression the chart will hide itself. Don't use double quotes around the expression.

You'll want to use something like =if(getselectedcount(MyField)>10,0,1) which would hide the chart if you select more than 10 values in the field MyField.

Re: Problem with Show conditional

beck_bakytbek — Thu, 18 Dec 2014 11:52:35 GMT

Hi Elena

You can use this simple expressions:

Conditional : GetSelectedCount(Company)>4,

so if i select more than 4 company. so my textbox will appear and if i selected lower than 4 Company, my textbox still hidding.

I hope, you´ll find it useful

Beck

Re: Problem with Show conditional

Thu, 18 Dec 2014 12:11:55 GMT

Create one chart(like bar chart) and also create two buttons,also one variable

1st button-text(set to 0),add action (select in field-give variable and value(=0))

2nd button-text(set to 1),add action(select in field-give the same variable and value(=1))

in the chart goto layout condition (variable=0 or =1)

based on 1 the chart will display, based on 0 the chart will hide

Re: Problem with Show conditional

tresB — Thu, 18 Dec 2014 12:20:38 GMT

If you are doing everything right(you believe) and still it is not hiding, there could be another possibility. Check the security settings(Settings->Document Properties->Security); uncheck 'Show All Sheets and Objects'.

Re: Problem with Show conditional

Thu, 18 Dec 2014 12:23:50 GMT

Try this at the Layout tab, Conditional field: if(count(distinct(Field))>0,0,1)

Hope it helps!

Best,

Re: Problem with Show conditional

Thu, 18 Dec 2014 12:37:47 GMT

To add to this, sometimes weird behaviour is scene when your chart is a copy of another chart. If that is the case, then try creating a new chart from scratch.

Thanks,

Singh

Re: Problem with Show conditional

Anonymous — Mon, 22 Dec 2014 15:16:58 GMT

Hi,

I'm trying to do this but I can't. Why I can't modify Document Properties?