topic Pivot table visualization in QlikView

Pivot table visualization

Fri, 30 Sep 2011 08:47:45 GMT

Hi,

I was wondering if someone of you knows how to replace the dates with the rslt_value in the pivot table shown below.

I've indicated what the resulting value should be.

Probably very easy, but I can't get it to work with a pivot table ( --> above you can see the result without the pivoting)

I used the aggr function for the regular chart

date(aggr(max(rslt_date),rslt_prsn,rslt_test),'DD/MM/YYYY')

but that does not seem to do the trick for me with the pivot table.

Thanks!

Ps: example included as well.

Regards,

Maarten

Pivot table visualization

Fri, 30 Sep 2011 09:03:10 GMT

HI,

have you tried with something like this?

sum(if(date(aggr(NODISTINCT max(rslt_date),rslt_prsn,rslt_test),'DD/MM/YYYY')=rslt_date,rslt_value))

C u,

Stefano.

Pivot table visualization

Fri, 30 Sep 2011 09:11:10 GMT

Excellent solution! 🙂

Thanks Stefano!

Btw: Is it possible to hide the column header "rslt_test" in the pivot table? (I know it is possible with regular chart tables, but the option seems to disappear when going to pivot table. It's just a an empty column ... (or is resizing it the only option :-)).

Pivot table visualization

Fri, 30 Sep 2011 09:18:43 GMT

U can't hide in pivot, but maybe u want hide only the header otherwise u lose "English, french ,german" dinamic column. If u want hide the header resize and put a space in label in dimension property of the table.

Stefano.

Re: Pivot table visualization

Fri, 30 Sep 2011 09:22:47 GMT

Thanks! That does look a bit neater 🙂

Have a nice day!!