Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Please find the attached document , I was to format the table in the document as below.. how is it possible
Thank you
You can not accomplish the exact view as in Excel. The expectation in QlikView pivot table is that values are grouped in each dimension over the value in previous dimension. Int his case the expected output would be as below.
In the provided sample this is prohibited by the Execution Date not being properly formatted as a date. You can see this by showing the field in a list box and adding a expression to reveal the underlying numerical values. The decimal values in this case technically means that each value corresponds to a timestamp and not a date. This is the reason why the same date is shows multiple times in the list box, instead of the expected one occurrence per date.
Dates are expected to have integers as numerical values, which means in this case the decimal part need to be removed during load. This can be corrected by applying Floor() on the Execution Date field during load.
Date(Floor([Query Start Time])) as [Execution Date]
Thank you for the response .. is there a way that I can show just the summary link for each result id somehow .. because it does make sense to show the same link twice for each result id .. is that possible?