Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
d_ankusha
Creator II
Creator II

Comparative Analysis

How to do comparative analysis in QLIKSENSE without using extensions?

1 Solution

Accepted Solutions
Digvijay_Singh

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.

View solution in original post

2 Replies
juraj_misina
Luminary Alumni
Luminary Alumni

Hi,

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

Juraj

Digvijay_Singh

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.