Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nachiket_shinde
Contributor III
Contributor III

Meaning of symbol '@' in set analysis

Hello Friends,

Please help me in evaluating below expression

  count(Distinct {<

[Sell_status] = {'Available'},

CreateDate  = {'@(=max(date(CreateDate)))'},

Dispatched ={@(vflag)}

>}[sellid])

Need to understand purpose of '@'

Thanks in advance

7 Replies
Anil_Babu_Samineni

Are you getting values using "@"

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Specialist
Specialist

Have check that the Syntax is showing correct at top in Expression tab like it shows Expression is OK?

Anil_Babu_Samineni

Expression default shows Ok because we are calling with in the Single and/or double quotes. In fact, I never used this. My Boss stalwar1‌ may know this..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Specialist
Specialist

Here not used in single quotes-

Dispatched ={@(vflag)}

so this will show an error.

I tried same expression and it is showing syntax error.

sunny_talwar

Is this expression defined in the script by any chance?

sunny_talwar

I am your friend Anil

Anonymous
Not applicable

count(Distinct {<

[Sell_status] = {'Available'},

CreateDate  = {'@(=max(date(CreateDate)))'},

Dispatched ={@(vflag)}

>}[sellid])

  in this case it gives distinct count for sell_status is available...it ignores createdate and dispatched...as they don't exist