Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

michael_anywar
Contributor

Fix Dimension basing on user values or certain specific values

I would like to fix the dimensions of the graph by years on the x-axis  either basing on user selection or if I can define my own values, that would also be great. AT the moment I used this:

({<Year={">=$(=min(StartYear))<=$(=max(EndYear))"}>}[GDP per capita (current US$)]) But it is not working.


If I can fix in the expression without using the StartYear and EndYear, that would be great.

Any help..? 

This would help compare either 2 years on just one specific. Will highly appreciate any help

Screen Shot 2018-05-16 at 16.51.51.png

Tags (1)
1 Solution

Accepted Solutions

Re: Fix Dimension basing on user values or certain specific values

Did you forget to add a sum or avg or something similar function?

Sum({<Year = {">=$(=min(StartYear))<=$(=max(EndYear))"}>} [GDP per capita (current US$)])

2 Replies

Re: Fix Dimension basing on user values or certain specific values

Did you forget to add a sum or avg or something similar function?

Sum({<Year = {">=$(=min(StartYear))<=$(=max(EndYear))"}>} [GDP per capita (current US$)])

michael_anywar
Contributor

Re: Fix Dimension basing on user values or certain specific values

Actually are right I thought the functions did't have  any issues but the do affect. Thanks Sunny.

Community Browser