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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Variable syntax

What is the meaning of variable vDate :  DATE =  {1} , MTD= {1}?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That variable is probably used in a set analysis expression like =Sum({< $(vDate) >} Amount). After the dollar expansion it would become =Sum({< DATE =  {1} , MTD= {1} >} Amount). That would calculate the sum of Amount over the set of records where Date = 1 and MTD = 1.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That variable is probably used in a set analysis expression like =Sum({< $(vDate) >} Amount). After the dollar expansion it would become =Sum({< DATE =  {1} , MTD= {1} >} Amount). That would calculate the sum of Amount over the set of records where Date = 1 and MTD = 1.


talk is cheap, supply exceeds demand