Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dhavalvyas
New Contributor II

Values Show in Chart as per Given Range with RGB on Click of Button

Hi,

As I am working on Qliksense for One of the Insurance Company.

My Client Requirement is on the selection of Button Value should show as per range in Charts on Click of Button.

For eg: My Limit for Expression Value is <=60,so Chart has Expression Value <60 only Show in RED Color on Click of RED Button and Other Values Should Hide.

            My Limit for Expression Value is >60<=80,so Chart has Expression Value >60<=80 only Show in GREEN Color on Click of         GREEN Button Other Values Should Hide.

            My Limit for Expression Value is >81,so Chart has Expression Value >81 only Show in AMBER Color on Click of AMBER Button Other Values Should Hide.

7 Replies
Highlighted

Re: Values Show in Chart as per Given Range with RGB on Click of Button

Hi Dhaval, I think the easiest way is creating a variable to control wich button has been pressed, each one sets the variable to one value (1,2,3). There are extensions to set variable values with buttons, ie:

http://branch.qlik.com/?_ga=1.210588061.985162163.1474569887#!/project/56728f52d1e497241ae697f8

Expression for button 1 variable can be: If($(VariableName)=1, 4, 1) // 4 to show all values

And different expressions with Pick():

Pick($(VariableName)

, Expression1 // red

, Expression2 // green

, Expression3 // amber

, Expression4 // all

)

MVP
MVP

Re: Values Show in Chart as per Given Range with RGB on Click of Button

This can be done without an extension although the buttons might not behave perfectly like normal buttons - try it out and see if it works for you:

2018-04-04 10_57_27-Qlik Sense Desktop.png

The selection boxes RED, GREEN and AMBER works with a single click actually. It would have been nice to get rid of the looking glass and avoid getting the X and V up when clicking - there is no need to press either of them....

Re: Values Show in Chart as per Given Range with RGB on Click of Button

I will prefer a mix of a variable extension that sets the range value using your expression, maybe with all set analysis in variable value to allow show all records.

But I take note of the idea, I really liked it.

MVP
MVP

Re: Values Show in Chart as per Given Range with RGB on Click of Button

Yes Ruben - I agree - it is not pretty - but if you have an environment where you can't use extensions this could be a "life saver".

dhavalvyas
New Contributor II

Re: Values Show in Chart as per Given Range with RGB on Click of Button

Hi peter After Selecting on Red or Amber or Green it is showing Values..but I want that if I am not selecting any of Filter it should show all values and as on Filtering particular Red or Amber or Green It should show as per its Respective Range that what you have done...

Please Check and Kindly help me out Please..

Thanks in Advanced...

Re: Values Show in Chart as per Given Range with RGB on Click of Button

Hi Dhaval, based on Petter sample you can create the range values as N={"<=60"}.

And use as:

Sum({<$(=RANGE)>} N) // in expression and bg color expression

And remove the conditional calculation on add-ons tab to show when there are no values selected.

dhavalvyas
New Contributor II

Re: Values Show in Chart as per Given Range with RGB on Click of Button

Hi,Petter

It shows values on Filtering RED,AMBER and GREEN..But without Filtering it should show all the values and after applying filters it should show respective values in which color range falls accordingly..??

Community Browser