Hi Frank,
Sorry for the trouble , This requirement is Qliksense .I attached the test data .
My Requirement is Current block and previous block information is there.
I have taken one table box and it's , I took Previous block as Dimension, Remaining things consider as a Measures just like
Count({$<Month_Year= {$(=MAXSTRING(Month_Year))},Current block={'A'}>}Match(Current block,Previous block))/
Count({$<Month_Year= {$(=MAXSTRING(Month_Year))}>}Match(Current block,Previous block)) ---For A of Current Block
Vise versa B ,C ,D, E also same .in the table box measure i taken individually ---(I took 5 measures ---1 for A, 2 for B ,3 for C like)
In Qliksense table box :-
Based on the condition I have given color codes. Count Values <=5 is Blue color and Count Values >=5
is red color,If Current and Previous is Equal it shows Green.
My Requirement is: I want to display the sum of the all red color values, Every column and every row wise .Please can you help me.
![Problem Screen shot.PNG Problem Screen shot.PNG](https://community.qlik.com/t5/image/serverpage/image-id/26225i2465AEB117265FCF/image-size/large?v=v2&px=999)
Thanks,
Ram