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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i use variable in set analysis?

pls tell the answer

Labels (1)
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
Support
Support

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)