Removing all values or recreating from xml causes permanently hidden charts

[mhouck01]

I have an issue with a .qvw file that I can't quite figure out. I was trying to backup the file and didn't want to back up all the data, so I went to File... Reduce Data... Remove All Values. Several charts disappeared, but that was expected, since there are several conditional statements in the application. When I reloaded the data, however, many of those charts stayed hidden no matter what I selected or tried. One of them that disappeared has a conditional around the main dimension... but the "Enable Conditional" checkbox is not even enabled.

I then found information on how to save a document as .xml files only using the "AppName-prj" folder in the same directory. I saved a version of the file which had data in it to that directory which populated the -prj folder. Then I removed that .qvw file, created a new blank file in that directory, renamed it to AppName, and reopened it in QlikView. When the file was recreated, the same issue happened. Charts were missing, and stayed missing even after the data was reloaded. I saved the file with a new name generated the same xml documents in a new -prj file and everything in there seemed to be exactly the same.

I'm not sure what's happening here... but it seems like whenever I remove all the data from this file something breaks and certain charts become permanently hidden.

Does anyone have any guidance here as to what to do or things that I could test?

[Anonymous]

Did you try to use "show all sheets and objects" in the document properties?

you can also get access to hidden objects from the sheet properties - objects, and change any object properties you want.

[Gabriel · Accepted solution]

Hi,

Open the qvw file and select Ctrl + alt + S (Settings -> Sheet Properties) then click Objects tab, there you should be able to find all the objects in the qvw file. Here you will see a section for ShowMode this will tell you objects which is hidden, select the object of your interest then click on the properties at then bottom right corner of the dialog. Once this object opens click Layout tab and go to Show section comment out the Show Hide logic and Click ok. This object should stays open  until you change the Show Condition on the Layout tab.

Show All Sheet is an options hold Ctrl + Shift + A this shows all hidden objects

Hope this helps

[rwunderlich]

What version (build) of QV?

[mhouck01]

I figured out what the problem was... this isn't my application and I found a bug in the creator's coding.

The layout condition of the table was set to look at an inline table value %CalcToggle = 'Average'. There was a list box in the report which pointed to %CalcToggle and I selected Average... but the table still did not show up. I went through some testing with text boxes and tried everything... until I realized that the creators of the application had created an alternate state for the Table that was disappearing. The list box that toggles between Average and Total was using the default inherited state.

So this looks like a bug in their program... the Alternate state must have been set at one time during their development but then they removed the list box to control it. So when I removed all of the data the AS's %CalcToggle was set to null and there was no way to set it back.

Thanks for your help... I completely forgot about the Layout condition (was only checking dimension and measure conditions) so I wouldn't have found the actual issue without the suggestion.