topic Re: Conditional View Not Working in QlikView

Conditional View Not Working

Mon, 08 Sep 2014 09:24:49 GMT

Hi Everyone

I have multiple companies data into single QV file.

And different chart for each company.

Want to show only the selected company chart.

Used a variable for each company and set its value to 0 or 1, depending upon company selection.

Used this varible in charts Property - Layout - Show - Conditional.

Problem is the variable value is set correctly but Chart is not getting Hide - Shown unless file is reopened.

Thanks in advanced.

Re: Conditional View Not Working

vardhancse — Mon, 08 Sep 2014 09:30:41 GMT

Create a button ->Action->Variable: 1,0

So based on the button click variable value will change and conditional hide/show will happen

Re: Conditional View Not Working

avinashelite — Mon, 08 Sep 2014 09:45:57 GMT

Hi Rajeshri,

I think all the variables are getting set at the same time i.e. is why its not hiding.

instead of creating multiple charts, try using single selected value in the company list box. This will show single company data based on the selection.

If you face any issue please post your app.

Re: Conditional View Not Working

Mon, 08 Sep 2014 09:49:13 GMT

I had diff formats for each.

Just now setting one variable only and tried to hide - show single chart.

As sasi said, tied with button as wel, but not working.

When I reopen the file, charts get Shown-Hide as per selection.

Written a small macro, which sets the variable to 0-1.

Re: Conditional View Not Working

avinashelite — Mon, 08 Sep 2014 09:52:09 GMT

Hi Rajeshri,

Its not so complex , no need of macro. please post your app. will check the issue and provide you the solution.

Re: Re: Conditional View Not Working

Mon, 08 Sep 2014 10:01:39 GMT

Hi Avinash

Thanks for your reply.

Please find attched sample file, which has same kind of situation.

Depending upon the selection of type want to show one of the chart.

Re: Re: Re: Conditional View Not Working

ashfaq_haseeb — Mon, 08 Sep 2014 10:10:46 GMT

Hi,

to do this I would suggest you to apply section access.

Or have a look at work around solution, with this you will have access to all companies data but only one visible at a time.

Regards

ASHFAQ

Re: Re: Re: Conditional View Not Working

avinashelite — Mon, 08 Sep 2014 10:12:27 GMT

Hi Rajeshri,

Please find the attachment for the soultion.

Re: Re: Re: Re: Conditional View Not Working

Mon, 08 Sep 2014 10:22:47 GMT

I had used GetFieldSelections (Type)='Purchase' in Condition. Same as in attched file but not working in my file.

are there any settings that needs to be done.

Re: Re: Re: Re: Conditional View Not Working

Mon, 08 Sep 2014 10:24:45 GMT

Yes Got it

Show All Sheet and Objects was set in my file.

I unset this option and now its working fine.

Thanks a lot ..........

Re: Conditional View Not Working

avinashelite — Mon, 08 Sep 2014 10:57:58 GMT

cool.....