topic Re: How to nullify the selection in this bar chart !!! Little tricky !!! in App Development

How to nullify the selection in this bar chart !!! Little tricky !!

rajuamet — Thu, 23 Feb 2017 11:14:28 GMT

Hi Techies,

For this bar chart, I have some conditions, please help me to achieve that.

Conditions:

1. Colors are fixed (ash and blue)

2. The chart should not change on selection. For example, if I select kamal or any name the chart should remain same.

How do I nullify the selection !!!

Here I have attached a sample app to play around.

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

Anonymous — Thu, 23 Feb 2017 11:27:05 GMT

For the colours change the colour to expression and then use an expression like;

If (year = 'CY', RGB(165,165,165), if(year = 'PY', RGB(90,155,213)));

To stop the chart changing on selections you need to place a {1} in your expression, something like;

=sum({1}Value)

The {1} marker defines the record set to ALL.

Thanks

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

rajuamet — Thu, 23 Feb 2017 12:14:35 GMT

Hi Gareth wilson,

For colors I have already done what you said. But for selection {1} is not working. Because, even when I select Kamal

it should display like this

and not like this

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

Anonymous — Thu, 23 Feb 2017 12:39:00 GMT

Could you post the expression, I havent got sense on this laptop to open the app

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

rajuamet — Thu, 23 Feb 2017 12:57:34 GMT

Hi Gareth Wilson,

Here I have attached qlik view app.

Expression:

IF(type='CY' ,sum({1}CYSales),

if(type='PY',SUM({1}PYSales)))

NOTE: My requirement is for qlik sense.

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

Anonymous — Thu, 23 Feb 2017 13:33:13 GMT

The if statement is throwing off the set analysis marker.

try using

sum({1}if(type='CY',CYSales,PYSales))

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

Anonymous — Thu, 23 Feb 2017 13:39:32 GMT

And for your colours;

You create expressions for colors in the properties panel.

Do the following:

In the properties panel, open Appearance > Colors and legend.
Click the Colors button to switch to Custom.
In the drop-down list, select the option By expression.An expression text box is opened.
Enter If (type = 'CY', RGB(165,165,165), if(type = 'PY', RGB(90,155,213))) in the text box

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

rajuamet — Thu, 23 Feb 2017 13:52:43 GMT

Hi Gareth Wilson,

Excellent!!!

But I have a catch here. In real scenario I will use something like this (should have mentioned earlier),

Expression:

IF(type='CY' ,sum({<$(vSetForCurrentYear)>}Sales),

if(type='PY',SUM({<$(vSetForPreviousYear)>}Sales)))

in this case I can not put the sum outside if.

How do I achieve this....

Re: How to nullify the selection in this bar chart !!! Little tricky !!!

shraddha_g — Wed, 01 Mar 2017 05:39:39 GMT

In this case try using

IF(type='CY' ,sum({1<$(vSetForCurrentYear)>}Sales),

if(type='PY',SUM({1<$(vSetForPreviousYear)>}Sales)))