2 very important questions

[#1]

Hi All,

I have to questions.

first one is as follows:

I want a chart that has columns that show something like this: Column 1 : year 2008 month dec, column 2: year 2008 month nov. Column 3: year 2007 month december.

can someone tell me how should i get something like this?

My second question is : how to connect oracle data base with qlikview. For SAP we use sap connection, provide our server IP and client. How is this done in Oracle data base system?

Prompt respond will be appreciated much! 🙂

Maria

[Anonymous]

Hi,

For your Graph issue, you can concatenate Month and Year and have a Month - Year Dimension in a normal graph. You can do this with a Calculated Dimension, or create an adicional Field in the load script.

To connect to an oracle DB, you can use ODBC or OLE DB drivers, as if you would connect to SQL Server.

You need to have an oracle client installed in order to be able to select the correct odbc/OleDb Driver.

Hope this helps,

Miguel Catalão

[#3]

no my question for graph was pertaining to the set analysis. how can i have current year and year year in the same chart....

whats the code like?

[deepakk]

hi,

I have attach a sample file for Current month, previous month and Last year , month.

I hope this helps.

to conenct to Oracle your require Oracle Client.

[#5]

where should i install the oracle client from?

[Anonymous]

Sorry but from your post i didn't get what you were asking...

I think Deepak's answer is correct.

You have to instal the oracle client from the installer CD or you can download the correct version from Oracle's internet Site.

[deepakk]

hi,

Only on the system where you want to retriving the data and store it.

This data will be used in applictaion. And the application can be shared or viewed by others using different QV Licneses

[sushil353]

hi mariakesc,

for oracle client connection go through the document...[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8156.QlikView-Connection-to-Oracle.doc:550:0]

i hope it will help you......

::))

[#9]

Hi everyone,

Thank you very much for your responses! 🙂

[rahulgupta · Accepted solution]

Hey Hi,

For the 1st Issue:

You can use set analysis as deepak has defined in his example or you can do in some other way as

>>By making a Dimension less Pivot chart, Use three expressions as:

 a). sum({<Year={'2008'},Month={'Jan'}>} sales)
 b). sum({<Year={'2008'},Month={'Nov'}>} sales)
 c). sum({<Year={'2007'},Month={'Dec'}>} sales)

For the 2nd Issue:

You have to install an Oracle Client such as "Toad" for the OLE-DB connection to work..

Hope this solves your issue....