topic Re: Hide chart (or image) object based on QlikView variable value in Qlik NPrinting

Hide chart (or image) object based on QlikView variable value

Thu, 21 Jan 2016 08:50:43 GMT

Hi everyone,

I have a QlikView variable and I want to show one of the chart (or image, or even text) in NPrinting report when this variable has value 1 and don't show in vice versa.

How I can do this?

Thanks in advance.

Re: Hide chart (or image) object based on QlikView variable value

Anonymous — Thu, 21 Jan 2016 11:48:45 GMT

It appears that this thread might get you some advice on how to solve your issue.

Access to hidden tabs?

Re: Hide chart (or image) object based on QlikView variable value

Thu, 21 Jan 2016 11:55:30 GMT

Unfortunately, no.

I know how use hidden QlikView objects in NPrinting. But I want to hide chart (for example) in NPrinting report according to variable value.

For example I want to show 2 charts in my report everytime. But if my QlikView variable vShow has value = 0 - I want hide one chart in my NPrinting report.

Re: Hide chart (or image) object based on QlikView variable value

Anonymous — Thu, 21 Jan 2016 18:43:08 GMT

When you say hide, do you mean not show the whole chart or just not show the rendered data and keep the outline of the chart in place. It would seem that you could use vShow in your calculated condition on your object and place an error message in the middle of the chart if it does not meet the condition. See these examples below. You calculated condition would be if your variable was 0 or 1.

Then it would render your chart with a message that you designate. That would hide your data.

Will that meet your need?

Mike

Re: Hide chart (or image) object based on QlikView variable value

Fri, 22 Jan 2016 08:00:06 GMT

I'll try to describe in such example.

- I have a QlikView variable vShow. (this variable could have value 1 or 0).

- I have NPrinting XLS report and I can get value from this vShow variable.

- I have many images in my NPrinting reports, for example 10 images.

- I want to show image number 8 (for example) only when my variable vShow has value = 1.

How I can do this?

P.S. I know that I can use 2 copy of my XLS tamplate (with image 8 and without), but I should have only one tamplate.

Re: Hide chart (or image) object based on QlikView variable value

Wed, 03 Feb 2016 07:17:57 GMT

Guys, any suggestions here?

Maybe I can use macros in Excel\Word template and work with this variable value from Macros?

Re: Hide chart (or image) object based on QlikView variable value

Wed, 03 Feb 2016 09:18:13 GMT

Thanks Mike,

Can you answer me how I can avoid such situation?

If I have this message:

How I can hide such IMG object in my NPrinting report?

When i have IMG - I just want show it

When I have "Selection Status: No selection" - I don't want show it.

Thank you vey much.

Re: Hide chart (or image) object based on QlikView variable value

Anonymous — Wed, 03 Feb 2016 13:54:14 GMT

Hi Valerii,

There was another thread like this recently. Nprinting does not have a conditional show for an object on a report. Personally, I would like it to be able to hide a column, an object or even a whole page based on conditions. I have a project where I had to create two templates based on whether I wanted to show certain objects or pages. Perhaps in a future release this will be available, for now it appears that you need to control the output manually. Sorry I could not be more helpful.

Re: Hide chart (or image) object based on QlikView variable value

Wed, 03 Feb 2016 13:59:32 GMT

Thank you Mike!

Your answers were very helpful.

Re: Hide chart (or image) object based on QlikView variable value

sagarkharpude — Thu, 20 Apr 2017 10:24:20 GMT

Hi,

Is this issue resolved in the next release. Because I want to use conditional show in the Word report of Nprinting.

Thanks