Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
NavinReddy
Contributor II

How to how expressions in X-axis

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

9 Replies
anushree1
Valued Contributor II

Re: How to how expressions in X-axis

Please provide the sample data

NavinReddy
Contributor II

Re: How to how expressions in X-axis

Thank you very much for your reply,

i have attached the sample dashboard could you please check.

anushree1
Valued Contributor II

Re: How to how expressions in X-axis

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 

NavinReddy
Contributor II

Re: How to how expressions in X-axis

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

anushree1
Valued Contributor II

Re: How to how expressions in X-axis

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

NavinReddy
Contributor II

Re: How to how expressions in X-axis

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

anushree1
Valued Contributor II

Re: How to how expressions in X-axis

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 

NavinReddy
Contributor II

Re: How to how expressions in X-axis

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

anushree1
Valued Contributor II

Re: How to how expressions in X-axis

Check the attached...

Is this what you are trying to get