Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i develop scatter chart instead of barchart with same dimensions

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.

1 Reply
IAMDV
Master II
Master II

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