Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: What are different Comparative Analysis formula?

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

Re: What are different Comparative Analysis formula?

Using gauges, getting variance (differences)

Community Browser