Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
!Hi,
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
=if(source_system='XYZ',median(JobEndTime-JobStartTime),NULL())
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.
Thanks,
Sreekar
The aggregation function is just a device to be able to use a Set expression. If there is only one qualifying row, It should give the same result.
-Rob