Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have run into an unfamiliar expression in a script I have been working on:
From [..\2_QvdGenerators\2_DW\Trans Order.qvd] (qvd)
Where Left(YYYYMM_Sales,4) >= '$()';
what does the '$()' stand for if it is 'empty'?
Thanks
In Qlik, the dollar sign, $, is used as an identifier to define the relationship between the set expression and the field values or expression being evaluated. The $() syntax is used for dollar-sign expansion, which evaluates the values inside the parentheses and returns the result to create the expression. If the parentheses are empty, as in your example, it means that there is no expression to evaluate and nothing will be returned. Please refer to the post below to see a further discussion of the same
What does this $ mean? - Qlik Community - 926455