Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

d_ankusha
Contributor II

Comparative Analysis

How to do comparative analysis in QLIKSENSE without using extensions?

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Comparative Analysis

One alternative to alternate state is through island tables. Keep separate island tables for needed dimensions. Let user make selections in these island tables fields, based on the selections use the conditions in your measures through set analysis in the charts  and comparitive visualization can be created.

For example. You can have two separate filters of time period. Base Period and Current Period. Use the selections of the period in the measure's set expression through getfieldselections function. It will aggregate values based on selected time period.

2 Replies
juraj_misina
Valued Contributor

Re: Comparative Analysis

Hi,

maybe this article (and example app in that article) might lead you:

Juraj

Digvijay_Singh
Honored Contributor III

Re: Comparative Analysis

One alternative to alternate state is through island tables. Keep separate island tables for needed dimensions. Let user make selections in these island tables fields, based on the selections use the conditions in your measures through set analysis in the charts  and comparitive visualization can be created.

For example. You can have two separate filters of time period. Base Period and Current Period. Use the selections of the period in the measure's set expression through getfieldselections function. It will aggregate values based on selected time period.