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
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
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
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.
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