Solved: variable with conditions - Qlik Community

JuRoss · ‎2023-10-18

hello im new to qlik sense and i want to create a varible but i dont know the syntax for qlik sense:

in SQL i would write:

Select <tbl1.test> from tbl1 where tbl1.date =getdate()

Can you help me tranlate this to qlik syntax

Aasir · ‎2023-10-19

Create a variable in Master items
as Variable_Name = Only({<tbl1.date={"$(=Date(Today()))"}>} tbl1.test)

you can use this variable in a text object or expression within a chart to display the value

= Variable_Name

This will display the value of tbl1.test where tbl1.date matches the current date.

Mark_Little · ‎2023-10-18

You need to set or let the value

Then to call depends on if it needs return what is kept in the Variable or evalulated.

vVariable

or

$(vVariable)

JuRoss · ‎2023-10-19

thank you for your help

I understand the two diffent types but i still dont no how to set it up.

I have:
LET vtest = and now i need the Select <tbl1.test> from tbl1 where tbl1.date =getdate() in Qlik Syntax.

I already know getdate()=Today() but i could need some more help with the rest.

Aasir · ‎2023-10-19

Create a variable in Master items
as Variable_Name = Only({<tbl1.date={"$(=Date(Today()))"}>} tbl1.test)

you can use this variable in a text object or expression within a chart to display the value

= Variable_Name

This will display the value of tbl1.test where tbl1.date matches the current date.

variable with conditions