Conditional View Not Working

[#1]

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.

[vardhancse]

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

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

[avinashelite]

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.

[#4]

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.

[avinashelite]

Hi Rajeshri,

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

[#6]

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.

[ashfaq_haseeb]

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

[avinashelite · Accepted solution]

Hi Rajeshri,

Please find the attachment for the soultion.

[#9]

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.

[#10]

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