Avoid making changes to the chart when certain selections are made

[reporting_neu]

Hello,

In my report there is a chart with three different complaint types (dimensions). These can be clicked in order to be able to see the corresponding characteristics in a table. In addition, the historical values ​​of the complaint types are each displayed in a bar chart. So for each type of complaint, a diagram.

If a selection is now made in the diagram with the three complaint types, the diagrams with the individual complaint types should not change. However, you must change other selections such as date or distribution center.

It is currently the case that when I make a selection for a complaint, two of the three diagrams become empty. In this case, however, they should remain unchanged.

I have already tried "Complaint type =, Complaint type = 3". I would like to always have complaint type 3 and at the same time a selection in the field should not be taken into account. Unfortunately that doesn't work. Do you have an idea?

[HugoRomeira_PT]

Hi there,

If I understand correctly the use case, is that despite the fact that you are "forcing" a certain chart expression to be blocked on complaint type = 3, sometimes when you apply filters on other charts, it affects that one as well.

This is most probably due to the data associations which can create an impact on the data available on the data set of the "complaint type 3 chart".

Imagine, if someone applies a filter on "complaint type"=2 this will result on Qlik selecting only the months/dates for when complaint type 2 were logged. Meaning that despite the fact you are "forcing" a chart to be locked on complaint type = 3 it will be affected.

For this type of scenario where you must have full control on users selections I normally use the Set analysis with identifier 1, to ignore all selections, and define only the ones I intend the user to use.

COUNT({1<Complaint_Type={3}, Year=p(Year), DateID={'>=$(Min(DateID) <=Max(DateID)'}> ComplaintID}

I hope it helps.

[reporting_neu]

Hi, thanks for your answer.

I had already tried "{1<." But the problem with this is that I can only use fixed filters. If the user additionally wants to restrict something, such as a distribution center, this restriction is no longer honored.

I was hoping there was another option 😊

[HugoRomeira_PT]

Hi,

But you can give them that possibility by using the p() option inside of set analysis.

example:

COUNT({1<Complaint_Type={3}, DistributionCenter=p({<Complaint_Type={3}>}DistributionCenter)> ComplaintID}

The p() means possible values, and it's going to allow the user to interact with the "distribution center" in order to filter.

[reporting_neu]

I don't even know the P function. Thanks for the tip.

Now I still have the problem that {1< is ignored 😑

This is what my formula currently looks like:

Count({1<[VST_Call.ypA_Year] = {$(=max(Year(today())))},[VST_Call.xCallart] = {12}, S_Custom.DistributionCenter=p({<VST_Call.xCallart={12}>}S_Custom.DistributionCenter)>}distinct [VST_Call.Callnumber])

Did I miss something?  

[HugoRomeira_PT]

The expression seems to be right, only thing missing is that you need to exclude the fields that may impact the distribution center options available (example: VST_Call.ypA_Year)

See bellow:

Count(
{1<[VST_Call.ypA_Year] = {$(=max(Year(today())))}
  ,[VST_Call.xCallart] = {12}, 
   S_Custom.DistributionCenter=p({<
                                   VST_Call.xCallart={12},
                                   [VST_Call.ypA_Year] = {$(=max(Year(today())))}
                                 >}S_Custom.DistributionCenter)
>}distinct [VST_Call.Callnumber])

If you need futher assistance let me know 🙂

Best regards

Hugo Romeira

[reporting_neu]

OK, now I understand more 😀
Unfortunately, I can't exclude  the field "VST_Call.xCallart", if a different callart (like 10) has been selected.

Then no data is displayed again, instead of staying with callart 12, no matter what callart was previously selected.

I added "VST_Call.xCallart= "to the formula to exclude a selection.

Count(
{1<[VST_Call.ypA_Year] = {$(=max(Year(today())))}
 ,[VST_Call.xCallart] =, [VST_Call.xCallart] = {12}, 
 S_Custom.DistributionCenter=p({<
                                [VST_Call.xCallart] =, VST_Call.xCallart={12},[VST_Call.ypA_Year] = {$(=max(Year(today())))}>}S_Custom.DistributionCenter)>}distinct [VST_Call.Callnumber])

[HugoRomeira_PT]

Let me know if you need additional help 😉

[reporting_neu]

I neeeed your help again 😁

---

@reporting_neu wrote:

Unfortunately, I can't exclude  the field "VST_Call.xCallart", if a different callart (like 10) has been selected.