topic 2 very important questions in QlikView

2 very important questions

Mon, 11 Apr 2011 11:27:10 GMT

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

2 very important questions

Anonymous — Mon, 11 Apr 2011 11:46:29 GMT

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

2 very important questions

Mon, 11 Apr 2011 11:49:42 GMT

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?

2 very important questions

deepakk — Mon, 11 Apr 2011 11:52:37 GMT

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.

2 very important questions

Mon, 11 Apr 2011 11:53:30 GMT

where should i install the oracle client from?

2 very important questions

Anonymous — Mon, 11 Apr 2011 12:00:13 GMT

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.

2 very important questions

deepakk — Mon, 11 Apr 2011 12:01:30 GMT

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

2 very important questions

sushil353 — Mon, 11 Apr 2011 12:08:57 GMT

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

::))

2 very important questions

Mon, 11 Apr 2011 12:17:36 GMT

Hi everyone,

Thank you very much for your responses! 🙂

2 very important questions

rahulgupta — Mon, 11 Apr 2011 12:27:50 GMT

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

2 very important questions

deepakk — Mon, 11 Apr 2011 13:27:05 GMT

hi Rahul,

This a static approach. If two mothns down the line if they want to see for different month and year..?? then ??

2 very important questions

rahulgupta — Mon, 11 Apr 2011 14:28:15 GMT

hey hi Deepak,

This answer was given by me according to the scenario Maria had given...

There is no such Data depicting the Logic for Dynamic Data...

and the dynamic logic can easily be built according to Static implementation....

2 very important questions

Tue, 12 Apr 2011 07:27:49 GMT

how do have code if we donot want this static approach, months definitely need to me changed but the idea still remains the same. current month current year, previous month with current year and previous year with current month.

please help

2 very important questions

deepakk — Tue, 12 Apr 2011 08:15:24 GMT

hi,

Above I have added test.qvw application. It contains the dynamic approach

2 very important questions

Tue, 12 Apr 2011 10:45:55 GMT

yes deepak.

how are variables used in qlikview?

2 very important questions

deepakk — Tue, 12 Apr 2011 13:04:07 GMT

hi,

Variable can store input from users or Values from certain conditions. This variable can be used in expression like below

Sum(Filedname = { $(Variable)} Amount).

When ever you are using variables in expression you need to use a $ sign and ( ) brackets.

2 very important questions

deepakk — Tue, 12 Apr 2011 13:13:25 GMT

ops.. the expression will be

Sum({<Filedname = { $(Variable)} >} Amount).

2 very important questions

Wed, 13 Apr 2011 10:58:59 GMT

deepak,

this is the syntax for using variables?

are these variable automatically set like that?

2 very important questions

deepakk — Wed, 13 Apr 2011 16:38:09 GMT

hi,

this syntax for writing variable in set analysis. variables are normally used inside $ like

$(Variable)

no they are not automatically set , we need to write it.