topic Re: How to how expressions in X-axis in QlikView

How to how expressions in X-axis

NavinReddy — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

can someone help me, how to show all expressions in X- Axis,i have attached the sample requirement this is what im trying to implementing in qlikview, please help me

Thanks in Advance

Navin

Re: How to how expressions in X-axis

anushree1 — Wed, 06 Feb 2019 06:34:16 GMT

Please provide the sample data

Re: How to how expressions in X-axis

NavinReddy — Wed, 06 Feb 2019 06:41:59 GMT

Thank you very much for your reply,

i have attached the sample dashboard could you please check.

Re: How to how expressions in X-axis

anushree1 — Wed, 06 Feb 2019 06:51:58 GMT

I was under the assumption that , the png file is the desired output, but it does'nt seem so.

Could you please let us know what is the desired output here, as it is not very clear

Re: How to how expressions in X-axis

NavinReddy — Wed, 06 Feb 2019 07:12:45 GMT

the requirement is i have to show all the months in X- Axis, i am planning to display all months in single column.

Re: How to how expressions in X-axis

anushree1 — Wed, 06 Feb 2019 07:21:22 GMT

ok so create a Month Field in the script as Month(Datefield) as Month, Now add this Month as Dimension in your chart, then add your expression as count(distinct FCT_SETUP_ID), that should take care of the Months accordingly.

If its not clear , please send the data and I shall compose the chart accordingly

Re: How to how expressions in X-axis

NavinReddy — Wed, 06 Feb 2019 07:29:59 GMT

it is their monthyear , i have used the monthyear as dimension and i tried with the count(distinct FCT_SETUP_ID) expression, here i want to use two dimensions in barchart, i think here i am getting the issue, not sure how to resolve the issue, i want to show two dimensions in bar chart one dimension in X- Axis, second dimension in Y- Axis.

any idea

Re: How to how expressions in X-axis

anushree1 — Wed, 06 Feb 2019 07:52:04 GMT

Right so use 2 Dimensions and a single expression instead of 12 expressions for each monthyear, as you will be adding Month Year in Dimension, you need not add an expression for each of the Month Year.

Furthermore you cannot have multiple expressions and Multiple Dimensions on Bar Chart, as it impacts the readability and gets skewed, try to visulaize the components you are adding

Re: How to how expressions in X-axis

NavinReddy — Wed, 06 Feb 2019 09:13:20 GMT

i tried with one expression and two dimensions but still its not working for me,
Could you please help me

Re: How to how expressions in X-axis

anushree1 — Wed, 06 Feb 2019 10:42:32 GMT

Check the attached...

Is this what you are trying to get