topic Re: Need to 2 dimension in different axis and 1 expression in qlikview chart. in QlikView

Need to display 2 dimension in different axis and 1 expression in qlikview chart.

karthik_vp — Thu, 08 Aug 2019 16:15:42 GMT

Hi All,

I have two dimensions and 1 expression, which needs to display in a chart.

Dimensions:

Dimension 1 : Status (values A,B,C,.....)

Dimension 2: No of Days (1,2,3,4,.....)

Expressions:

Expression: count(distinct InvoiceNumber)

I want to show Dimension 1 in X axis and Dimension 2 in Y axis. Can anyone help me on how we can create the chart. I have attached the rough graph in this post. Please find it and kindly do the needful.

Thanks in advance!!!!!!

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

Anil_Babu_Samineni — Thu, 08 Aug 2019 16:15:28 GMT

Create Scatter Chart and use same dimensions and Measure.

Note: Second dimension should holds numeric data

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

karthik_vp — Thu, 08 Aug 2019 16:27:00 GMT

Hi Anil Babu,

Thanks for Immediate response.

In the scatter chart, I have add Status and No of Days as dimension. (please check screenshot1)

and in the expression tab, it is asking to select fields for x and y axis. (please check screenshot2). Here I have added status as x axis field and No of Days as Y axis field. But still Chart is not populating what I expected.

Screenshot1

Screenshot2

Thanks!!!!!

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

Anil_Babu_Samineni — Thu, 08 Aug 2019 16:56:33 GMT

Not expected means? It is not coming or data predict is not valid?

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

karthik_vp — Thu, 08 Aug 2019 17:08:25 GMT

I am getting the chart like below.

It is not showing like in the rough graph which I attached in my first post.

IN the Y axis the values should be 1,2,3, but it is showing in 0.1,0.2 etcc...

In Xaxis the values should show A,B,C......, but it is showing in numbers.

and invoice count is showing at 0.0 coordination.

Thanks!!!!!

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

Anil_Babu_Samineni — Thu, 08 Aug 2019 17:09:09 GMT

Odd to explain. Can we get sample data set?

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

karthik_vp — Thu, 08 Aug 2019 17:26:38 GMT

Hi Anil,

Please find the sample data file attached to this post. Thanks in Advance!!!!

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

Anil_Babu_Samineni — Thu, 08 Aug 2019 17:35:12 GMT

Like this?

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

karthik_vp — Thu, 08 Aug 2019 17:39:33 GMT

Yes, this is good!!!!. Can you share the sample qvw file?

Thank you so much!!!!

Re: Need to 2 dimension in different axis and 1 expression in qlikview chart.

Anil_Babu_Samineni — Thu, 08 Aug 2019 17:41:31 GMT

Straight Forward, PFA