topic Reports in QlikView

Reports

stephenedberkg — Thu, 11 Feb 2016 06:07:57 GMT

i have the pivot table with conditionally show.

while creating the report i drag the pivot table into report page but it's display only the layout not the values..

Re: Reports

tresB — Thu, 11 Feb 2016 06:11:40 GMT

Even when the condition is true? If the condition is false, the behavior is expected.

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:16:59 GMT

even without conditional also its not displaying

Re: Reports

ramasaisaksoft — Thu, 11 Feb 2016 06:25:56 GMT

Hi Stephen,

Y don't you create a new Pivot table without applying any condition may be it will help to .

You can use this in Report editor

Re: Reports

HirisH_V7 — Thu, 11 Feb 2016 06:29:10 GMT

Hi,

Yes when you conditionally hide it will show only layout as Box.But only when the condition is show the Object will be shown in that layout Box.

When you hide it will be like this,

When you show it will be like this,

Do you want to remove that box or what?

HTH,

Hirish

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:33:59 GMT

i want to show the value in reports.

but my pivot chat is always showing the null values in the box.

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:34:58 GMT

thanks Ram

is there any alternative way?

Re: Reports

tresB — Thu, 11 Feb 2016 06:38:03 GMT

Could you share your qvw with sample data?

Re: Reports

jagan — Thu, 11 Feb 2016 06:40:42 GMT

Hi,

The only way is before viewing the report you need to set the condition true for the pivot table so that the object is visible in the report.

Or create other Pivot table and minimize it, now use this object for Report.

Regards,

Jagan.

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:47:42 GMT

Thanks Jagan

but without conditional also my pivot chat only display like this

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:54:08 GMT

Dear tresesco

in my sample qvw its displaying correct.

Re: Reports

jagan — Thu, 11 Feb 2016 06:57:03 GMT

Hi,

It is working correctly for me. Delete it and then create again, sometimes it works.

Regards,

jagan.

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 06:59:40 GMT

Jagan

if i set the stretch as clip its displaying correctly

Re: Reports

jagan — Thu, 11 Feb 2016 07:03:25 GMT

Not Sure. Fill with Aspect not working? If no problem then set it as clip.

Regards,

Jagan.

Re: Reports

stephenedberkg — Thu, 11 Feb 2016 11:39:01 GMT

not working Jagan

Re: Reports

ramasaisaksoft — Thu, 11 Feb 2016 11:49:26 GMT

Hi Stephen,

Condition 1:- if you requirement is OK convert this chart to Straight table and drag to report if it works fine

Condition 2:- create a new sheet in report page and drag only this pivot table

Condition 3:- I hope it is small pivot table so try to create a new qv file using Binary load and check there if it works fine then some times Free QV Desktop edition will have this issues.

may be these conditions are solve your issue.