Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks,
Ram