topic Re: What am I doing wrong here in QlikView

What am I doing wrong here

Anonymous — Fri, 12 Jan 2018 06:09:19 GMT

I have attached an app where I have tried to create a bubble chart similar to what hic‌ has beautifully illustrated here Creating a Scatter Chart‌ but I have failed so far.

below are the requirements

X-axis - Time (I have aggregated time stamps)

Y-axis - Count(TRANSACTION_DATE)

size of bubble - to be determined by sum(Revenue)

and I want to see all these by Regions.

Issue: I tried to put Count(TRANSACTION_DATE) in the Y axis, but just could not. Y axis is always taken by Region.

Count of Transaction_date is the frequency of transaction and I want to measure that in the Y axis. how to make that possible.

Re: What am I doing wrong here

hic — Fri, 12 Jan 2018 06:59:24 GMT

You have chosen "Grid chart" instead of Scatter chart.

HIC

Re: What am I doing wrong here

Anonymous — Fri, 12 Jan 2018 17:43:56 GMT

Thank you Henric. I am making improvements.

After changing the chart type to grid chart, i checked advanced mode box and it allowed me to include 3 expressions:

1) this is my x axis where i want to see time (time stamp aggregated to day- level). but it is not understanding my expression (which is correct) that aggregates. its not letting simple transaction_date in the x-axis either. its counting transaction_date which is supposed to happen only in the 2nd expression

2) count(transaction_date): i intend to treat this expn. as Y-axis which is working well

3) sum(revenue): this is supposed to determine the bubble size, which is as expected.

one last issue: the bubbles are connected with a straight line as well. how to get rid of that.