topic Re: How do I make it read only(static report) report? in QlikView

How do I make it read only(static report) report?

srinivas1921 — Wed, 10 Feb 2016 18:06:57 GMT

Hi,

As per requirement, In single sheet based on condition, I performed drilling on first chart (straight table) then it will shows next chart(straight table).same way I performed drilling from on 2nd chart then it will shows third one table box.the table box is last level only.in this last level, how do I make it static report(read only).there is no read only option in table box like straight table and even i selected read only option in sheet level then I couldn't performed drilling on first chat and second chart.I don't want filtered the data from table box chart.Just I want static report in the last level table box report.please suggest me solution on this.

Many thanks in advance for u r great support.

Re: How do I make it read only(static report) report?

Wed, 10 Feb 2016 19:54:37 GMT

Generally Straight table have read only but not Table Box. So while user go to Level 3 activate the Table box in the new sheet and add the Read only on sheet Level.

Sheet Properties --> Security --> Select Read only

Re: How do I make it read only(static report) report?

harsh44_bhatia — Wed, 10 Feb 2016 20:00:39 GMT

Hi,

Not sure why you want to use Table box at the last level. You can also use a straight table with =1 as expression and then in presentation tab hide the expression column.

Also for drill down may be you can consider creating drill down group dimension that might help in your case.

Share some sample file so that specific prob can be addressed

Re: How do I make it read only(static report) report?

maxgro — Wed, 10 Feb 2016 20:09:14 GMT

workaround

add a transparent text box over the tablebox and adjust the layer in layout tab

Re: How do I make it read only(static report) report?

rwunderlich — Thu, 11 Feb 2016 02:29:48 GMT

You don't even need the =1 expression to make the dimensions appear. Instead uncheck "suppress zero values" on the Presentation tab.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How do I make it read only(static report) report?

harsh44_bhatia — Fri, 12 Feb 2016 04:20:28 GMT

Hi Rob,

Yes, i tried it worked. i could reason out one thing, that if i do not mention any aggregation function, QV will internally use ONLY() function and since it will return NULL, we will get the record set.