topic Re: Ad-hoc reporting in QlikView

Ad-hoc reporting

Sun, 04 Dec 2011 00:17:57 GMT

Hi All,

I am kind of new to QlikView and I have been hearing from several people that QlikView lets users create their own reports/analytics easily. Does that mean users need to learn how to use the QlikView desktop? If yes, isn’t it too technical for users to write expressions/formulas/set analysis etc? Also, if users are creating the reports/analytics, would they deploy it themselves? Can anyone please let me know their thoughts on this? Thanks in advance for helping.

Re: Ad-hoc reporting

IAMDV — Sun, 04 Dec 2011 15:44:38 GMT

Hi,

I would say yes and no to your question. I am saying yes because users can create their own analysis with QV 11. I mean users can use the Conditional Enabling of Dimensions and Facts. I mean this feature was lacking in previous versions of QV and we need to write lot of VB Script to achieve this effect. However with version 11, it is much easier for user to play with pre-defined dimension and facts/expressions. This works like a pivot table in Excel and this feature is available in other BI vendords. Here is the QV example of this feature and personally this is one my favourite feature in QV 11.

Apart from this users can create their own charts objects using existing dimensions from the data model. Here is the link on how it works.

I said no, because users will not use QV Desktop Edition to create their own analysis/ reports (unless they wanted to...)

I hope this helps!

Cheers - DV

Ad-hoc reporting

Sun, 04 Dec 2011 17:30:47 GMT

The second link you pointed me to is to a blog(not a specific link). Can you please provide more details? Do we need to create a data model(QVW file) and load it into memory? How does that work?

Re: Ad-hoc reporting

IAMDV — Tue, 06 Dec 2011 11:03:00 GMT

Hi,

Sorry for not explaining in detail. Please click on the second link and watch the first video. This video demonstrates on how users can create their own analysis. Yes, we still maintain the QV document and that means we load the data into the memory. Users create their objects by using current data model. And these objects are saved for that specific users.

I hope this helps!

Cheers - DV

Re: Ad-hoc reporting

Tue, 27 Dec 2011 15:15:19 GMT

Hi D V,

Like you, from all QV11 features I like the Conditional Enabling the most. I've seen a demo model that someone wrote using this feature. Still I'm looking for more examples.

Do you know how can I get the QV11 Demo - i.e. the .qvw file, so I can see it's script ?

Thanks,

Yigal

Re: Ad-hoc reporting

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 15:57:05 GMT

Hi Yigal,

Go to the demo site:

http://demo.qlik.com

And click on the demo you want to see, then click on "View Details". There you are the Download (.QVW) link that will let you save the file for your perusal.

Hope that helps.

Miguel

Re: Ad-hoc reporting

Thu, 29 Dec 2011 11:52:48 GMT

Thanks Miguel. I succeeded to download the demo.

Yigal

On Tue, Dec 27, 2011 at 5:57 PM, Miguel Angel Baeyens <

Re: Ad-hoc reporting

Fri, 07 Sep 2012 04:38:57 GMT

Hi Miguel,

I have a question about containers, which I use a lot:

(sorry that it's not connected to this thread, but I wanted to address it to you...)

can't write more then 1 line on a container tab
when placing a straight table in the container, or when chart dimentions exceed the container width, no horizontal scroll bar appears
can't find a way to identify (in a macro for example), which tab was selected (tab index)

btw, how do I report a bug to QlikView team ?

Thanks,

Yigal