Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sibrulotte
Contributor III

Pivot table with text as expression

Hi,

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

calendar.png

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.

4 Replies

Re: Pivot table with text as expression

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
Contributor III

Re: Pivot table with text as expression

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.

Re: Pivot table with text as expression

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
Contributor III

Re: Pivot table with text as expression

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

Community Browser