Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using function Qualify and Unqualify Statment

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

13 Replies
Not applicable
Author

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

Not applicable
Author

tried but getting Heading value for each row

marcus_sommer

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

Not applicable
Author

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