topic Analytics with query in QlikView

Analytics with query

Tue, 02 Aug 2016 21:31:23 GMT

Hi there,

I want to use an select statement to analyze my data that is already loaded into Qlikview.

With other words I do not want to use the mouse and click on table entries to select them, but I want to write a statement that selects the data.

Example (it is an SAP access rights analysis)

Data is already loaded in QV.

Table 1:

Right	Field	from	to
F_BKPF_BUK	BUKRS	1000	2000
F_BKPF_BUK	ACTVT	01	02
F_BKPF_BUK	ACTVT	*
F_BKPF_BUK	ACTVT	01	05

Columns are displayed in different select boxes. But due to the fact that access rights always change, I do not want to make the selections by hand all the time but automate the selection.

So, is there a possibility to create a button, an action, a bookmark or whatever in which I can dynamically query something like:

SELECT *

FROM table1

WHERE Right = "F_BKPF_BUK"

AND Field = ACTVT

AND ((from > 3 AND to < 7) OR (from = '*'))

In the next step I want to fill a list with many rights queries and try to automate all the selections, but first things first.

Thanks a lot for your support,

Martin

Re: Analytics with query

swuehl — Tue, 02 Aug 2016 21:40:04 GMT

I am not exactely sure if I understood what you want to achieve and why you are using QV to do this, but maybe look into

a) actions you can trigger e.g. using a button click, specifically the Selection - Select in field action

b) set analysis:

A Primer on Set Analysis

Re: Analytics with query

Siva_Sankar — Wed, 03 Aug 2016 01:44:01 GMT

Martin,

you can do one time selection to get the result equivalent to sql output and then bookmark the result. The create a trigger to apply the bookmark when it is opened or create a button to apply the bookmark as mentioned above by stefan