Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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
Highlighted
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)

View solution in original post

4 Replies
Highlighted
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

Highlighted
krishna_2644
Valued Contributor III

Re: Using Variables in Chart Expressions or Measures

Please See attached.

It might help you.

thanks

krishna

Highlighted
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

Highlighted
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)

View solution in original post