Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mrthomasshelby
Contributor

Display all values including repetitive Dimension values in a Scatter Plot?

I have a dataset as shown below:

Month    Stock      Price

2              A            21

2              B            33

2              A            46

2              C            54

2              D            59

2              C             63

2              E             72

I'd like to show these values on a Scatter plot: With Stock as the dimension, Month as the X-axis and Price(without any aggregation) as Y-axis. I've tried this but the Stocks A and C are not being shown in the plot. Is there any way to show A and C, twice in this instant with their different prices in the Scatter plot? If not please suggest a different but similar chart where I can show all the above points.

TIA.

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Check the attached

Stock_trend.JPG

12 Replies
OmarBenSalem
Esteemed Contributor

Re: Display all values including repetitive Dimension values in a Scatter Plot?

As dimension:

Stock

As measure:

1) Month

2) =AGGR(NODISTINCT sum(Price),Stock)

result :

Capture.PNG

mrthomasshelby
Contributor

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Hello omar bensalem,

Thanks for the reply. But you see I don't want to Sum the Prices. I want to display each and every point in the dataset above. That is I need A to be shown as two points: One point with price 21 and other with 46. Similarly, C should be displayed twice: one point with price 54 and the other with price 63. Is there a way to do so? TIA.

OmarBenSalem
Esteemed Contributor

Re: Display all values including repetitive Dimension values in a Scatter Plot?

I don't know how to do that; stalwar1‌? vinieme12‌ ?

vinieme12
Esteemed Contributor II

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Group your Data by Stock and the instance of each Price that occurs and use the new Field as Dimension

LOAD *,Stock&'-'&AutoNumber(Stock&Month&Price,Stock) as Stock_New INLINE [

Month,Stock,Price

2,A,21

2,B,33

2,A,46

2,C,54

2,D,59

2,C,63

2,E,72

];

vinieme12
Esteemed Contributor II

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Check the attached

Stock_trend.JPG

OmarBenSalem
Esteemed Contributor

Re: Display all values including repetitive Dimension values in a Scatter Plot?

That's brilliant and correct; but suppose we do not have access to the script; and we had to make this directly within the scatter plot? How should we proceed?

vinieme12
Esteemed Contributor II

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Don't know, but me let try me a few things and get back

OmarBenSalem
Esteemed Contributor

Re: Display all values including repetitive Dimension values in a Scatter Plot?

Is there any way of generating autonumber-like numbers directly within the charts?

The ponly way I could think of is using a dimension like this:

=Stock&'- Month'&Month&' Price :'&Price

Capture.PNG

vinieme12
Esteemed Contributor II

Re: Display all values including repetitive Dimension values in a Scatter Plot?

You can use Rowno()

=AGGR(Stock&'-'&Rowno(),Stock,Month,Price)

Attaching updated app

Community Browser