Discussion board where members can get started with QlikView.
How to get one dimension on x axis and other dimension on y axis in barchart
i have data like this :
Project No(WP Numbers) ,PlannedDate(DD-MM-YYYY), hrs
Y Axis its show Project Number.X Axis it's show dates of planneddate.
Startdate of particular Emp(MR X) for particular Project.
Enddate of a particular Emp(MR X) for particular Project.
and inside the bar formed i want the hours worked by that Emp(MR X) for that Project.
Please find the below screen shot.
Sorry i was unable to understand your question properly.
if my assumption is correct,
you are expecting Date column on X -axis so you need to be add Start date/End Date column in Dimension of the bar chart so
Dimension : Start date (or) End date
Expression : Sum(hrs)
correct me if i wrong understood your requirement.