topic Re: RE:Pass to Variable in QlikView

RE:Pass to Variable

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i want to pass the field into a variable

below is my code

let vVar= If(MonthStart(OrderDate)= MonthStart(Today(1)),1,0); /// this one

sample:

LOAD

Product,

"Year",

"Month",

"OrderDate",

If(MonthStart(OrderDate)= MonthStart(Today(1)),1,0) as CurrentMonth,

Sales

FROM [lib://Data/sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

same i passed to variable but its not working any other way to achieve this?

i want to compare if data is available for current month display 1 orelse 0

thanks

Chanty

Re: RE:Pass to Variable

Clever_Anjos — Fri, 01 Dec 2017 11:01:10 GMT

SET vVar= If(MonthStart(OrderDate)= MonthStart(Today(1)),1,0); /// this one

sample:

LOAD

Product,

"Year",

"Month",

"OrderDate",

$(vVar) as CurrentMonth,

Sales

FROM [lib://Data/sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: RE:Pass to Variable

Chanty4u — Fri, 01 Dec 2017 11:04:08 GMT

thanks clever

the script which i am using giving me correct but the variable is not working

but the variable result am getting null as a field it is giving me correct.

but i want the variable to use in Nprinting

Re: RE:Pass to Variable

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:04:33 GMT

Seems working with SET rather LET

Re: RE:Pass to Variable

Clever_Anjos — Fri, 01 Dec 2017 11:06:18 GMT

would you mind testing my solution and giving feedback?

Re: RE:Pass to Variable

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:07:12 GMT

Seems working in field too

LET vVar= If(MonthStart(OrderDate)= MonthStart(Today(1)),1,0);

LOAD *,If(MonthStart(OrderDate)= MonthStart(Today(1)),1,0) as CurrentMonth Inline [

Product, Year, Month, OrderDate, Sales

A, 2017, 1, 12/1/2017, 10

B, 2016, 5, 12/10/2016, 20

C, 2015, 10, 10/10/2015, 30

];

LOAD * Inline [

FieldName

'$(vVar)'

];

Re: RE:Pass to Variable

Chanty4u — Fri, 01 Dec 2017 11:24:13 GMT

your way it works but that i dont need clever

Re: RE:Pass to Variable

Chanty4u — Fri, 01 Dec 2017 11:24:57 GMT

yes anil its working but same variable am giving as a condition in npritning it is not working

Re: RE:Pass to Variable

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:28:03 GMT

I don't even what is N-Printing. May be i am going to kick that.. Not sure how to call in N-Printing.

Re: RE:Pass to Variable

Chanty4u — Fri, 01 Dec 2017 11:31:41 GMT

there will be one option like condition there we can pass qlik variable

so now am passing above variable like when my report having latest month data the report should send to customer or else it should not send

this is my requirement. now the variable is working but when i test in nprinting the report is not generating even though current month data is there .

Re: RE:Pass to Variable

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:37:49 GMT

Can you show image exact where you are passing and what was that? I assume, You need to set

vVar / $(vVar) / '$(vVar) / Same with All equal signs. Test with these 6 levels

Re: RE:Pass to Variable

Chanty4u — Fri, 01 Dec 2017 12:09:26 GMT

No No anil in npritning it will give drop down to select the variables which you have created in qlik

Re: RE:Pass to Variable

Anil_Babu_Samineni — Fri, 01 Dec 2017 12:13:59 GMT

May be move this to N-Printing section rather Qlikview then? As i am not handy with N-Printing