topic Re: filtering one part of a combo plot in QlikView

filtering one part of a combo plot

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a combo plot (line and bar plot). I want to filter the data that generated the bar plot and NOT the line plot.

The plot has been created using the following:

X as Dimension

Y as Experssion (Line plot)

Z as Expression (Bar plot)

The expression for Z is basically a frequency: =(Count(X)/count(ALL(X)))*100

What I want to do do, is filter the calculation of Z based on the value of V, i.e., only calculate Z for the rows where V='A'

does it make sense to write the expression as follows:

=(Count({<V={'A'}>} X)/count({<V={'A'}>}ALL(X)))*100

Thanks.

Anil_Babu_Samineni — Tue, 01 Aug 2017 09:20:34 GMT

I am not following you, But by luck you can use TOTAL keyword rather ALL

=(Count({<V={'A'}>} X)/count({<V={'A'}>} TOTAL X))*100

What I want to do do, is filter the calculation of Z based on the value of V, i.e., only calculate Z for the rows where V='A'

What you mean, Z based on the value over here?

Tue, 01 Aug 2017 09:24:07 GMT

I want to calculate Z i.e., the frequency here, ONLY based on the rows where V='A'.

Does the expression used actually return what I actually want?

What is the difference between Total and ALL ?

Anil_Babu_Samineni — Tue, 01 Aug 2017 09:28:04 GMT

Here is the link for 3rd question - Keywords : TOTAL, ALL & DISTINCT

Second question, How come we know whether what is business?

First question? Yes, If your frequency expression correct then off course, The condition true

Tue, 01 Aug 2017 09:35:57 GMT

from the explanation, I think total is what I want.

As in my case, the division in the Frequency should be calculated ONLY based on the count of rows where V='A'.

Anil_Babu_Samineni — Tue, 01 Aug 2017 09:49:11 GMT

Deserve It !!!