Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What are different Comparative Analysis formula?

Hi,

I have problem on setting up formulas for comparative analysis? Anyone can help me? Please let me know how to get the following...

  • Year-to-date vs. Last-Year-to-Date
  • Month-to-date vs. Last-Month-to-date
  • This Year vs. Last Year
  • This Month vs. Last Month

Thanks,

Bill

2 Replies
Not applicable
Author

I'm not sure if this has to be done with comparative analysis.

I can imagine that YTD vs last YTD can be done with setanalysis only (by substracting 1 year from the selected year for e.g.)

But if you want to do it with comparitive analysis this is possible too.

2 questions:

1: What is the issue you ran into?

2: And how should it work? (should there be one group of listboxes connected to both states? or 2 groups of listboxes (one for the normal state and one for the alternate state)

I'd like to hear

Not applicable
Author

Using gauges, getting variance (differences)