Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have created a 3 bar charts with dimension
GroupA
and expression is
=Count({$<[$(=GetCurrentField([GroupA]))]={">=$(g2GroupAVar1)<=$(g2GroupAVar2)"}>} [Value])
GroupB
and expression is
=count ( {$<[$(=GetCurrentField([GroupB]))] = {">=$(g2GroupBVar1)<=$(g2DGroupBVar2)"}>} [Value])
GroupC
and expression is
=count ( {$<[$(=GetCurrentField([GroupC]))] = {">=$(g2GroupCVar1)<=$(g2GroupCVar2)"}>} [Value])
when i select any group(i.e Group A, B, C) i am getting output in barchart which i have created as follows:
Output
and expression is
=Count({$<[$(=GetCurrentField([MeasurementsGroup]))]
=P({<[$(=GetCurrentField([GroupA]))]={">=$(g2GroupAVar1)<=$(g2GroupAVar2)"}>*<[$(=GetCurrentField([GroupB]))]={">=$(g2GroupBVar1)<=$(g2GroupBVar2)"}>*<[$(=GetCurrentField([GroupC]))]={">=$(g2GroupCVar1)<=$(g2GroupCVar2)"}>} [$(=GetCurrentField([MeasurementsGroup]))]),[Value]
=P({<[$(=GetCurrentField([GroupA]))]={">=$(g2GroupAVar1)<=$(g2GroupAVar2)"}>*<[$(=GetCurrentField([GroupB]))]={">=$(g2GroupBVar1)<=$(g2GroupBVar2)"}>*<[$(=GetCurrentField([GroupC]))]={">=$(g2GroupCVar1)<=$(g2GroupCVar2)"}>} [Value])>} [Value])
Now i want the output in scatter chart when i select the groups(i.e Group A, B, C)
I am facing difficulty to write 2 expressions in scatter chart for the output
whereas bar chart only needs 1 expression which i have done(refer output expresssion)
How can i develop scatter chart with same dimensions instead of barchart?
If anyone can help me out that will be helpfull for me.
Hi,
This is very interesting! Yes, indirect analysis is the way forward. Please can you post the QV document with sample data? This make it very easy for other fellow users to test the expression results and you will get quicker response.
Cheers - DV