I am new to Qlik view.This may seem like an amateur question.
I am building a line chart with year on the X-Axis which can be drilled down to month and median(JobEndTime-JobStartTime) on Y axis. I want the runtime for only one source system and so I am doing this
The chart is blank and says No data to display. It looks correct but I at a loss as to why it isnt calculating the median.
Any help would be appreciated.
Quick question - If I were to just subtract the two columns, then also, If is not working. If I want to do this,
This is also not working and I am not sure how I can use set analysis here. Its really confusing.
If you calculate on the dimension of year then for source system FDM and for a given year 2015 you have multiple values of start time and multiple values of end time so either you will have to sum or average those multiple values. If you had just a single value of start time and end time for 2015 then you could subtract and show on the graph. For better understanding I have created a table box and list box on sheet 2. Please review. There is no issue with if function.
For any year when you have multiple end and start date, there will be multiple subtractions. Then either you will have to sum or average those subtracted values to show as a datapoint for a particular year..2014 or 2015.