topic Re: Pivot table with text as expression in QlikView

Pivot table with text as expression

sibrulotte — Mon, 29 Feb 2016 14:38:29 GMT

Hi,

I've come across a question from a collegue that wants to work a calendar to follow tasks of his team.

Has anyone managed to thought of a way to display text in pivot tables as expression?

=only([]) doesn't work.

Each task has a slew of characteristics by wich to filter afterwards like clients, priority, frequency, etc.

He wants to easily select these criterias to see what goes on in that segment.

marcus_sommer — Mon, 29 Feb 2016 15:04:06 GMT

Yes, you could return strings within a pivot, like:

'x (' & sum({< Type = {'x'}>} Hours) & ')' & chr(10)

'y (' & sum({< Type = {'y'}>} Hours) & ')' & chr(10)

....

- Marcus

sibrulotte — Mon, 29 Feb 2016 15:07:04 GMT

true, but every task that is added, substracted to the workload has to be handled manually in the expression.

that's a good lead though thanks.

marcus_sommer — Mon, 29 Feb 2016 15:18:03 GMT

This might be possible in a more generic way with a concat and extend with a dual with something like this:

dual(concat(distinct Type & ' (' & sum(aggr(sum(Hour), Staff, Date)) & ')', chr(10), TypeID), sum(Hour))

- Marcus

sibrulotte — Mon, 29 Feb 2016 15:21:37 GMT

I'll have to try that, will let you know