Selection messes my sorting order

[paweln]

Hi All,

I have a KPI and a line chart.

X axis of line chart is [Counting Month]. KPI is responding to selections but I need line chart to be fixed so my measure on line chart is:

1-Count({1<Group={'A'}, Defect={'Yes'}>}Product)/Count({1<Group={'A'}>}Product)

If I choose [Counting Month] value my KPI works fine but selected month goes at the end of line chart making it meaningless.

is it that issue?

https://support.qlik.com/articles/000087436

How to solve it? Alternate state?

[Chanty4u]

use  like this in your line chat expression 

what ever the dimensions you have include like below.

Sum({<year=,month=>} Sales) 

[paweln]

Hi Chanty4u, it desn't work. You suggest to do it like this:

1-Count({1<Group={'A'}, Defect={'Yes'}, [Counting Month]=>}Product)/Count({1<Group={'A'}, [Counting Month]=>}Product)

but there is alreay "1" modifier that should work the same way as [Counting Month]=

[Chanty4u]

can you try this?

1-Count({1<Group={'A'}, Defect={'Yes'}, [Counting Month]=e( [Counting Month])>}Product)/Count({1<Group={'A'}, [Counting Month]=e( [Counting Month])>}Product)

[Kashyap_R]

Hi

Can u attach a sample qvf where you are facing this issue. so that anyone can try the same scenario.

Meanwhile

try removing the sorting for other measure keep only month dimension and remove sorting for other

Hope this helps 

Thanks  and Regards

Kashyap.R

[paweln]

Hi,

Chanty4u, that E() removes selected months from the chart. I don't want to touch dim (Counting Month).

kashyap, my sorting looks like this:

To upload the sample I would have to cut most of data model. I'll consider this. 

[Kashyap_R]

Hi

Can u please attach a sample qvf it will be easy to try and get the solution asap.