Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

Reports

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..

15 Replies
tresesco
MVP
MVP

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

stephenedberkg
Creator III
Creator III
Author

even without conditional also its not displaying

ramasaisaksoft

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

HirisH_V7
Master
Master

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,

Report HIde.PNG

When you show it will be like this,

Report show.PNG

Do you want to remove that box or what?

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
stephenedberkg
Creator III
Creator III
Author

i want to show the value in reports.

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

stephenedberkg
Creator III
Creator III
Author

thanks Ram

is there any alternative way?

tresesco
MVP
MVP

Could you share your qvw with sample data?

jagan
Luminary Alumni
Luminary Alumni

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.

stephenedberkg
Creator III
Creator III
Author

Thanks Jagan

but without conditional also my pivot chat only display like thisreport pivot.png