RE:Pass to Variable

[Chanty4u]

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

[Anil_Babu_Samineni]

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

[Chanty4u]

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

[Anil_Babu_Samineni]

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