Text Object - Multiple Rows Combining Dimension and Expression

Tue, 25 Oct 2016 10:29:57 GMT

I am trying to create a Text Object which gives me a Dimension, a Date and two Expressions, that will display multiple rows of data. This will be the basis for an Alert to be sent by email. The data is to be restricted by two filters. One is to restrict data to today (Is Latest = 1) and the other to show data count is down (Record Count Travel = -1).

The output I would like to see is:

report1 25/10/2016 550 500

report2 25/10/2016 600 590

report3 25/10/2016 700 680

Column 1 is the Dimension - [Report Name]

Column 2 is the Date - [Document Date]

Column 3 is the Count Today - [No of Records]

Column 4 is the Count Yesterday - [Prev Count]

The following works, if I physically filter "Is Latest" and "Record Count Travel", but I would like the result to apply even without the filters applied.

= concat( if([Record Count Travel] = -1, if([Is Latest] = 1, [Report Name]))

& ' ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [Document Date]))

& ' ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [No of Records]))

& ' ' & if([Record Count Travel] = -1, if([Is Latest]= 1, [Prev Count]))

& chr(13) )

I've tried some Set Analysis options too. Can't work it out...

Any help would be appreciated.

Kind regards

Tony

Re: Text Object - Multiple Rows Combining Dimension and Expression

sunny_talwar — Tue, 25 Oct 2016 16:07:45 GMT

May be like this:

=Concat({<[Record Count Travel] = {-1}, [Is Latest] = {1}>} [Report Name] & ' ' & [Document Date] & ' ' & [No of Records] & ' ' & [Prev Count], Chr(10))

Re: Text Object - Multiple Rows Combining Dimension and Expression

Mon, 14 Nov 2016 12:14:45 GMT

I worked out a different way to do this and used a Macro, to email a chart object instead.

topic Text Object - Multiple Rows Combining Dimension and Expression in QlikView

Text Object - Multiple Rows Combining Dimension and Expression

Re: Text Object - Multiple Rows Combining Dimension and Expression

Re: Text Object - Multiple Rows Combining Dimension and Expression