Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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.

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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.

View solution in original post

9 Replies
Highlighted
Specialist
Specialist

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

Access to hidden tabs?

Highlighted
Not applicable

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.

Highlighted
Specialist
Specialist

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.

calc cond.PNG

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

calc explantation.PNG

Will that meet your need?

Mike

Highlighted
Not applicable

No

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.

Highlighted
Not applicable

Guys, any suggestions here?

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

Highlighted
Not applicable

Thanks Mike,

Can you answer me how I can avoid such situation?

If I have this message:

222222.png

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.

Highlighted
Specialist
Specialist

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.

View solution in original post

Highlighted
Not applicable

Thank you Mike!

Your answers were very helpful.

Highlighted
Creator III
Creator III

Hi,

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

Thanks