topic Re: Conditional show objects on report in QlikView

Conditional show objects on report

Fri, 14 Feb 2014 17:01:57 GMT

Hi,

I have designed a QlikView report to show 3 charts one below the other. The requirement is to show only 2 charts based on a condition. But when the condition hides any of the first 2 graphs, it creates blank space in the report.

Is there any option available to arrange the 2 selected graphs one below other dynamically? I tried to adjust the left right properties, but it doesn't allow those to be configured using a variable dynamically.

Regards,

Murali

Re: Conditional show objects on report

Fri, 14 Feb 2014 17:08:50 GMT

can you post a visual example of what you mean? When the two graphs are hidden, can't you just make the single visible graph larger?

Re: Conditional show objects on report

Fri, 14 Feb 2014 17:13:41 GMT

You can play around with Conditional show/hide to achieve what you want.I think you are using Calculation Condition which calculates only when the condition satisfies. But when you use conditional show it will hide the entire.object.

But as mentioned by Paul it will be much easier to address if you could attach a sample file.

Thanks

Re: Conditional show objects on report

Gysbert_Wassenaar — Fri, 14 Feb 2014 17:14:14 GMT

Are you talking about a report designed with the Report Editor that opens when you choose Edit Reports from the Reports menu? If so then I'm afraid you're out of luck. I don't know of any way to make reports behave this way. If you're talking about a qlikview document then what you want is hard to do, but possible using a macro. See here: http://community.qlik.com/message/361796#361796

Re: Conditional show objects on report

Fri, 14 Feb 2014 17:25:18 GMT

Here is an example...

steps

1. Click on Print Report and then print preview.

2. You will notice all three text boxes in the report.

3. Now close that window and click on 'hide step2'

4. Now click on print report and then print preview.

5. Now you will see a gap between the two text objects.

what I want is to move move third text box just below the first one...

Re: Conditional show objects on report

fkeuroglian — Fri, 14 Feb 2014 23:47:50 GMT

Hi, as we know the reported tools is very limitated and have a lot of things to improve, one of this things is this bug that you mentioned previous.

if you have condition in some object, when they are hiden , the blank space will continue and the report will be not totaly correct.

Fernando

Re: Conditional show objects on report

Mon, 17 Feb 2014 12:01:05 GMT

Does any of the extension objects or 3rd party tools provide this functionality?

how about NPrinting?

Re: Conditional show objects on report

fkeuroglian — Mon, 17 Feb 2014 12:28:51 GMT

Hi,

With Nprinting you can do it, and it resolver ok, it is a good tool to use and have this functionality.. but is a no free tool and you have to purchase.

good luck!

Fernando

Re: Conditional show objects on report

Fri, 29 Aug 2014 08:08:58 GMT

Hi Fernando,

can you tell me how to do that in NPrinting?

Thanks!

Re: Conditional show objects on report

fkeuroglian — Sat, 30 Aug 2014 00:13:22 GMT

Hi Andreas,

Nprinting is a addition software that works in qlikview, and have a lot of advantages, you can see in this link how Nprinting works Customer Feedback for Vizubi

Let me know if you need something

Fernando

Re: Conditional show objects on report

Mon, 01 Sep 2014 13:04:13 GMT

Hi Fernando,

thank you for the information. I already worked (and am working) with NPrinting, but wasn't able to hide charts within a NPrinting report based e.g. on a variable value (e.g. using the Show - Condition property of the Object). You stated "With Nprinting you can do it", which I assumed was in response to the question of this thread "Conditional show object in report". So: Can you tell me how to do conditionally show/hide objects (or even report pages) in NPrinting reports?

Best regards

Andreas

Re: Conditional show objects on report

Thu, 21 Jan 2016 08:39:53 GMT

Yes, it's a very good question Andreas (and Muralidhar)!!

I have the same issue. I have a QlikView variable and I want to show one of the chart in NPrinting report when this variable has value 1 and don't show in vice versa.

How I can do this?

Re: Conditional show objects on report

Tue, 17 May 2016 05:29:42 GMT

Hi ,

Can you please help with the process how to conditionally hide the object using nprinting without leaving any blank spaces.