Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator 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
Specialist II
Specialist II

Please provide the sample data

NavinReddy
Creator II
Creator II
Author

Thank you very much for your reply,

i have attached the sample dashboard could you please check.

anushree1
Specialist II
Specialist II

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
Creator II
Creator II
Author

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

anushree1
Specialist II
Specialist II

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
Creator II
Creator II
Author

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
Specialist II
Specialist II

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
Creator II
Creator II
Author

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

anushree1
Specialist II
Specialist II

Check the attached...

Is this what you are trying to get