topic Re: using function Qualify and Unqualify Statment in QlikView

using function Qualify and Unqualify Statment

Mon, 10 Oct 2016 02:18:33 GMT

please give answer to use PEEK or any function within Qualify and Unqualify statement. below is eg script

QUALIFY *;

funcPEEKtbl:

LOAD Year,

Sales,

PEEK(Sales) As PeekfuncWrk

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

UNQUALIFY *;

result is NULL as done with below experiments

1. PEEK(Sales) As PeekfuncWrk

2. PEEK('Sales') As PeekfuncWrk

3. PEEK(funcPEEKtbl.Sales) As PeekfuncWrk

4. PEEK('funcPEEKtbl.Sales') As PeekfuncWrk

5. PEEK(funcPEEKtbl.Sales,-1,funcPEEKtbl) As PeekfuncWrk

6. PEEK('funcPEEKtbl.Sales',-1,'funcPEEKtbl') As PeekfuncWrk

but PEEK function works correctly without Qualify statment

Re: using function Qualify and Unqualify Statment

marcus_sommer — Mon, 10 Oct 2016 07:51:24 GMT

This should work:

PEEK([funcPEEKtbl.Sales]) As PeekfuncWrk

PREVIOUS(Sales) As PeekfuncWrk

- Marcus

Re: using function Qualify and Unqualify Statment

Mon, 10 Oct 2016 10:10:19 GMT

tried but not working. below is the original script

QUALIFY *;

funcPEEK2015Budgettbl:

LOAD Year,

[2015 Budget]

FROM

[Practicing Data Files\Data for func Peek and Previous1.xlsx]

(ooxml, embedded labels, table is [2015Budget]);

funcPEEK2016Budgettbl:

LOAD Year,

[2016 Budget],

Peek([funcPEEK2016Budgettbl.2016 Budget]) As funcBudgetPEEK

FROM

[Practicing Data Files\Data for func Peek and Previous.xlsx]

(ooxml, embedded labels, table is [2016Budget]);

UNQUALIFY *;

executed script successfully but field funcBudgetPEEK returns ' - ' value

Peek([funcPEEK2015Budgettbl.2015 Budget]) As funcBudgetPEEK

Re: using function Qualify and Unqualify Statment

sunny_talwar — Mon, 10 Oct 2016 11:42:17 GMT

Try this:

QUALIFY *;

funcPEEK2015Budgettbl:

LOAD Year,

[2015 Budget]

FROM

[Practicing Data Files\Data for func Peek and Previous1.xlsx]

(ooxml, embedded labels, table is [2015Budget]);

funcPEEK2016Budgettbl:

LOAD Year,

[2016 Budget],

Peek('funcPEEK2016Budgettbl.2016 Budget') As funcBudgetPEEK

FROM

[Practicing Data Files\Data for func Peek and Previous.xlsx]

(ooxml, embedded labels, table is [2016Budget]);

Re: using function Qualify and Unqualify Statment

marcus_sommer — Mon, 10 Oct 2016 12:02:21 GMT

With an inline-table it worked:

QUALIFY *;

t: load [a w], peek([t.a w]) as b, previous([a w]) as c inline [

a w

30];

UNQUALIFY *;

exit script;

Loading from an excel might require a slight different syntax whereby I suggest to rethink the whole qualify-approach then there is rarely an added-value with them rather the opposite with various problems, see also: Re: qvd's

- Marcus

Re: using function Qualify and Unqualify Statment

Mon, 10 Oct 2016 15:17:44 GMT

sorry to say but i need answer for external data instead of Inline

Re: using function Qualify and Unqualify Statment

Mon, 10 Oct 2016 15:19:10 GMT

in my first post (number 4) i already tried with single quote but no use

Re: using function Qualify and Unqualify Statment

sunny_talwar — Mon, 10 Oct 2016 15:40:50 GMT

I guess what Marcus meant was that you can use this:

Previous([2016 Budget]) As funcBudgetPEEK

Re: using function Qualify and Unqualify Statment

marcus_sommer — Mon, 10 Oct 2016 16:33:31 GMT

Please provide an excel data-example and take also into account that developing datamodels in qlik is much easier without qualifying which is even by mid-sized data-architectures not enough to control and overview the data-sources.

- Marcus

Re: using function Qualify and Unqualify Statment

Tue, 11 Oct 2016 03:54:37 GMT

i am in practice of qlikview. so i was practicing on different charts and functions in one .qvw file instead of separate .qvw. function is working Good without Qualify statement. thanks Marcus for ur words 'developing datamodels in qlik is much easier without qualifying'. i removed Qualify statement and practiced in different .qvw file, its working fine

Re: using function Qualify and Unqualify Statment

Tue, 11 Oct 2016 04:00:32 GMT

Generally asking below question

1. whenever i refresh my webpage, Views which is under my first Question (

using function Qualify and Unqualify Statment)

at bottom will keep increasing.

is it possible to stop that simply increment

2. Currently being moderated.

why this message will come everytime when i Add Reply. is that msg necessary everytime.

3. showing CORRECT ANSWER image. i think we should hv option of that button to mark when user gets correct result instead of showing for every reply

Re: using function Qualify and Unqualify Statment

Tue, 11 Oct 2016 04:02:40 GMT

tried but getting Heading value for each row

Re: using function Qualify and Unqualify Statment

marcus_sommer — Tue, 11 Oct 2016 06:53:49 GMT

1. it's just a simple counter (I'm not sure if more intelligence would be add more value)

2. it's a security measure against spam - I don't know the exact policy but with more (no harmful) questions/answers the rules will get less restricted

3. I think it's important to highlight directly helpful/correct answers to help other users with a similar topic

- Marcus

Re: using function Qualify and Unqualify Statment

Tue, 11 Oct 2016 11:46:20 GMT

just by refreshing counter will increase hahahahahahah

second point to be noted but need to wait till moderation completes very sad

thanks Marcus, for your answer to my general doubt