Merging Cells

Anonymous — Fri, 26 Aug 2016 21:21:20 GMT

Please find the attached document , I was to format the table in the document as below.. how is it possible

Thank you

Re: Merging Cells

ToniKautto — Sat, 27 Aug 2016 05:34:10 GMT

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]

Re: Merging Cells

Anonymous — Mon, 29 Aug 2016 03:41:00 GMT

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?

topic Re: Merging Cells in QlikView

Merging Cells

Re: Merging Cells

Re: Merging Cells