Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlikie
Creator
Creator

Selecting values which are included in a script

Hello together,

is there any possibility, that I can select different values (for example earliest year of a delivery (2009 or 2010 or 2011), medicinal product (Y / N),  etc) before I start a script?

1.) So I need to set some values which have to take account in the script.

Something like this:

Do you have a "medicinal product"? Y / N  => If I take Y, the data will be set in a variable (e.g. vMPdata='Y')

In the script should be something like this:

SQL SELECT SAARTNR  as REF,

    SAARTBEZ1 as Articledescription,

    SAMEDIK as AMKZ,

    SACHARKZ as LOTKZ

FROM QS36F.DLSSA where SAMEDIK=vMPdata;

2.) Also should there any checkup for all values I have to add. Only if I have added all values, I am able to run the sript

Do you have any ideas?

Thank you very much for your help.

11 Replies
newqlikie
Creator
Creator
Author

I do not undestand directly. Can you may be give me an example, or can you give me some script-commands which I need to use?

Thanks again.

Not applicable

Hi,

Say you have computed expression: max(sales), this wont work in script. You need to do some thing like Load max(sales) as maxSales Resident Sales; Peek() sales into a variable etc..

The reason is that while executing the script the fields sales is not intregrated will the entire datamodel and hence these functionality wont work. But variables are static values and can be passed during script execution.

Sorry I could not envision demostrating this with an example document.

Kiran.