Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please provide the sample data
Thank you very much for your reply,
i have attached the sample dashboard could you please check.
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
the requirement is i have to show all the months in X- Axis, i am planning to display all months in single column.
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.
any idea
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
i tried with one expression and two dimensions but still its not working for me,
Could you please help me
Check the attached...
Is this what you are trying to get