Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Comparison period

Hi All,

i'm new and i have a question, please you can help me.

Imagine that you have a file of sales, with a data field which coincide with the date of sale and another that coincide with amount

I would set the two filters display: the first is the selection period , while the second is the comparison filter, both chosen by the user.

The result is to obtain the data of sales in the first period compared to the second. What is the best approach in your opinion ?


2 Replies
Contributor II

Re: Comparison period


Maybe you ought use set analysis. In my case for example, I compare sales of two years: so I do

sum({$<year={"x"}>}value) VS sum({$<year={"y"}>}value) in two different KPI.

Clearly the set analysis in this case fix the period.

You can also add filters to choose for example one month: you'll have the comparison between month z in year x VS month z in year y.

Here a bit of documentation

A Primer on Set Analysis

Honored Contributor III

Re: Comparison period

You can think of using alternate states as well if you don't want to write set expressions

Community Browser