Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
use like this in your line chat expression
what ever the dimensions you have include like below.
Sum({<year=,month=>} Sales)
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]=
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)
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
Hi
Can u please attach a sample qvf it will be easy to try and get the solution asap.