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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i use variable in set analysis?

pls tell the answer

6 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Yes.

Variable vYear: 2015

Expression: sum({<Year={$(vYear)}>}Sales)


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

Yes you can

SUM({Dimension={$(variable)}}Sales)

Not applicable
Author

Hi Rahul,

sum( {$<Month = {$(vMonth)}>} Sales )

returns the sales for the given Month in relation to current selection.

prajapatiamar38
Creator II
Creator II

Yes,

Sure you can use variable in set analysis.

For example: SUM({< Customer_ID={"$(vS1)"} >}Sales)

Here vS1 is the variable name.


I hope this will help you.

Thanks

Not applicable
Author

Yes :

Variable:vCurPrd

Sum({$<WeekId={'>$(=max(WeekId)-(vCurPrd))'}>}trx)

Anonymous
Not applicable
Author

yes you can use.  sum({<Year={$(vCurrentYear)}>}Sales)