topic Re: Can i use variable in set analysis? in QlikView

Can i use variable in set analysis?

Mon, 25 May 2015 12:39:03 GMT

pls tell the answer

Gysbert_Wassenaar — Mon, 25 May 2015 12:40:08 GMT

Yes.

Variable vYear: 2015

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

Clever_Anjos — Mon, 25 May 2015 12:44:25 GMT

Yes you can

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

Mon, 25 May 2015 12:49:05 GMT

Hi Rahul,

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

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

prajapatiamar38 — Mon, 25 May 2015 13:03:37 GMT

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

Mon, 25 May 2015 13:08:58 GMT

Yes :

Variable:vCurPrd

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

Anonymous — Mon, 25 May 2015 13:14:31 GMT

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