Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Using Variables in Chart Expressions or Measures

Hi All.

I am quite new to Qlik Sense and trying to calculate Sales from Last Quarter vs This Quarter

So I have a Purchase Amount and a Purchase Date.

I set the following in the load Statement

LET vThisQuarter = 'Q' & Ceil(Month(Today())/3);

LET vLastQuarter = 'Q' & Ceil(Month(Today())/3-1);

Now I am trying to create the formula that will give me Q1 and Q2 sales.  I am not sure what to do.  Any suggestions.

Thanks,

David

1 Solution

Accepted Solutions
MVP
MVP

Re: Using Variables in Chart Expressions or Measures

Just use dollar sign expansion to replace the hard coded values with the variable content:

=sum({$<Quarter={'$(vLastQuarter)'}>}sales)

=sum({$<Quarter={'$(vThisQuarter)'}>}sales)

4 Replies
MVP
MVP

Re: Using Variables in Chart Expressions or Measures

Maybe have a look at this series of blog posts about using set analysis and point in time reporting

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync

krishna_2644
Valued Contributor III

Re: Using Variables in Chart Expressions or Measures

Please See attached.

It might help you.

thanks

krishna

Not applicable

Re: Using Variables in Chart Expressions or Measures

That is what I tried and it worked.  The problem is that hardcodes Q1 and Q2 into the formula.  I want to pass a variable so when the Q2 changes to Q3 I dont have to update the formula.

Does this make sense?

Thanks

David

MVP
MVP

Re: Using Variables in Chart Expressions or Measures

Just use dollar sign expansion to replace the hard coded values with the variable content:

=sum({$<Quarter={'$(vLastQuarter)'}>}sales)

=sum({$<Quarter={'$(vThisQuarter)'}>}sales)

Community Browser