QLIK VIEW OBJECT PROPERTIES

value showing frequency in Sheet objects:

Right click on the sheet object and select properties.
Go to General Tab and Check the Show Frequency box.

The number of times a value is repeating will be seen in the list box.
We can also display the value percentage.

Changing the sort order:

Right click on the sheet object and select properties.
Check the Sort Tab and see various options available.

Changing the Number format:

Right click on the sheet object and select properties.
Check the Number Tab and see various options available.

Aligning the values:

Right click on the sheet object and select properties.
Check the Presentation Tab and see various options available.

ASCP QUERY TO FETCH LATEST PLAN AND COLLECTION RUN DATES

Query to fetch Plan Latest run date:

SELECT MAX(ACTUAL_COMPLETION_DATE),ARGUMENT1 INSTANCE_CODE,ARGUMENT2 PLAN_ID
FROM FND_CONCURRENT_REQUESTS A, FND_CONCURRENT_PROGRAMS_TL B
WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
AND B.USER_CONCURRENT_PROGRAM_NAME = 'LAUNCH SUPPLY CHAIN PLANNING PROCESS'
--AND ARGUMENT1 = '' --INTANCE_CODE AND ARGUMENT2='' -- PLAN_ID
AND PHASE_CODE='C' AND STATUS_CODE='C'
GROUP BY ARGUMENT1,ARGUMENT2
;

This has to be joined with ebs table FND_APPS_SYSTEM.NAME to get exact instance and plan

-------------------------------------------------------------------------------------------------------------------------------------------------------
Query to fetch Collection Latest run date:

SELECT MAX(ACTUAL_COMPLETION_DATE),C.INSTANCE_CODE
FROM FND_CONCURRENT_REQUESTS A, FND_CONCURRENT_PROGRAMS_TL B,MSC_APPS_INSTANCES C
WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
AND A.ARGUMENT1=TO_CHAR(C.INSTANCE_ID)
AND B.USER_CONCURRENT_PROGRAM_NAME = 'PLANNING DATA PULL'
--AND ARGUMENT1 = '' --INTANCE_ID NO PLAN_ID ATTRIBUTE FOR THIS CONCURRENT PROGRAM
AND PHASE_CODE='C' AND STATUS_CODE='C'
GROUP BY C.INSTANCE_CODE
;

SELECT MAX(ACTUAL_COMPLETION_DATE),C.INSTANCE_CODE
FROM FND_CONCURRENT_REQUESTS A, FND_CONCURRENT_PROGRAMS_TL B,MSC_APPS_INSTANCES C
WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
AND A.ARGUMENT1=TO_CHAR(C.INSTANCE_ID)
AND B.USER_CONCURRENT_PROGRAM_NAME = 'PLANNING ODS LOAD'
--AND ARGUMENT1 = '' --INTANCE_ID NO PLAN_ID ATTRIBUTE FOR THIS CONCURRENT PROGRAM
AND PHASE_CODE='C' AND STATUS_CODE='C'
GROUP BY C.INSTANCE_CODE
;

This has to be joined with ebs table FND_APPS_SYSTEM.NAME to get exact instance and plan

WHAT ARE LINKED OBJECTS IN QLIK VIEW

If you want several objects to have the same layout properties, you can use linked objects. These are objects that share all properties with the exception of size, position and display state (minimized, normal or maximized). When you change the properties of one object the change is immediately reflected in the other linked objects. Linked objects can reside on the same sheet or on
different sheets.

To create a linked object:

1 Right-click a sheet object and select Copy to Clipboard - Object.

2 Right-click somewhere on the sheet (or on a different sheet) and select Paste Sheet Object as Link.

QLIK VIEW SHEETS

sheet can be considered the most basic component in QlikView. A document usually contains several sheets, which is useful when one wants to achieve a more structured layout. Any sheet object can be put on any sheet. The sheets will, however, still be logically connected, i.e. a selection made on
one sheet will affect all sheet objects on all other sheets.

Each sheet has a tab attached to it. Containing the name of the sheet, the tab helps you find the sheet you are looking for. By clicking on a tab, you activate the sheet attached to it. You recognize an active tab from the bold text.

Adding a sheet:

1. Choose Add Sheet from the Layout menu. A new sheet appears.
2. Click somewhere on the empty sheet with the right mouse button and choose Properties from the menu that appears. The Sheet Properties dialog will now appear.

Moving a sheet:

 Click on the tab of your newly created sheet withthe right mouse button. From the float menu that
opens, choose Promote Sheet it will move one sheet forward, click  demote it will move one sheet backward.

Adding new sheet objects:

If you right-click somewhere on the sheet , then select New Sheet Object, you see this list
of all the sheet objects that can be used in QlikView.

Moving a sheet object:

To move a sheet object we can use mouse or CTRL+Arrow or CTRL+SHIFT+Arrow.
Also we can undo our changes by using CTRL+Z.

QLIK VIEW LOCKING AND UNLOCKING SELECTIONS

The logic of QlikView by default replaces a previous selection with the new selection
if the previous selection is in conflict with the new selection.

To prevent this, selections may be locked. Locked cells are blue. A selection in conflict
with a locked selection will not be performed.

1. Choose Lock from the Selections menu or from the toolbar. This will lock all selections, preventing them from being cleared by mistake.
2. Select an excluded value in another list box and note that it is not possible.
3. To unlock all selections, choose Unlock from the Selections menu or from the toolbar.
4. It is also possible to lock fields individually by right clicking on the selection value.

INTRODUCTION TO QLIK VIEW

QlikView is a software that enables all kinds of users from beginners to experts to
retrieve and assimilate data easily from any source: databases like SQL Server or
Oracle as well as Excel, XML or text files. Enterprise applications such as SAP may
also be used as data source for a QlikView analysis.

QlikView offers a wide variety of graphs, charts and tables in different formats to
present your data the way you want.

Creating the interface is very easy and does not require help from the IT department. Any graphic
or table can be printed or exported to other programs for further processing.

Different types of Qlik View

1. QlikView standalone is freeware and can only be used in one system.
2. QlikView Server and QlikView Publisher that can be used for centralized management of          QlikView applications, for automated updates and for distribution of documents to several users.