Display detail values in summary chart - issue on date
Hi Experts,
I have combo chart with
Dimension as Month and
Expressions are Sum(revenue), Total Customer per day(Need to display as line in this chart)
Scenario
on X- Axis, i want to see All the Months and on Y- axis the bar should represent the Total Revenue by each month. So far it is taken care
The second expression in this chart should be a line and the date as to display the totals of that specific day
Eg:
January Total Revenue is 3000(displays as bar)
The line as to display as a trend for each day
Jan 1 Total 10 customers
Jan 2 Total 9 Customer
Note: January dates are not required to be displayed on the axis tab, instead it should just show Month name and the trending should be as day for the second expression(Total customer).
I am just trying to see if it something possible in QlikView any help would be appreciable.
I think and please correct me if i am wrong you changed in data to achieve the month name- When hover over on the trend line it is giving month name for all the trends, is there a way we can get actual date trend and also for the
Total Revenue bar, the sum value are populating duplicate sum, since there is only one row for revenue, i think it is calculating multiple times same values
