topic Re: hide column data but show total in QlikView

hide column data but show total

userid128223 — Fri, 23 Nov 2012 22:28:25 GMT

I have pivot table that show 3 columns of expression.

Time_Purchased Hours_Worked Time_Remaining

I have break on pivot table to show subtotals at comany level.

I want to hide time remaining for indvidual rows but still show time Remaining under subtotals.

When I make text color white() for that field total also gets changed.

Any insight on how I can achieve this.

thanks

Re: hide column data but show total

swuehl — Fri, 23 Nov 2012 22:36:49 GMT

You should be able to use dimensionality() (or secondarydimensionality(), if pivoted) function to check if the expression is evaluated in a (sub)total context. Create a new expression

=dimensionality()

or check the HELP on what is returned in each level of dimensionality. Then use something like

=if(dimensionality() < 2, sum(Time_Remaining), '')

Re: hide column data but show total

userid128223 — Thu, 29 Nov 2012 16:06:02 GMT

I have expression like below. how can i hide displaying each field an only display when it totals by company.

=Sum({$<BILLABLE = {'T'}, TimePurchaseDate = {'>=$(=ADDMONTHS(TODAY(),-12))'}>}TimePurchasedHours) - Sum({$<BILLABLE = {'T'}, ServiceDate = {'>=$(=ADDMONTHS(TODAY(),-12))'}>}HoursWorked)

Re: hide column data but show total

Thu, 29 Nov 2012 16:53:58 GMT

Hi animu ,

You go to properties->Presentation->

select the column name and click on hide column

Re: hide column data but show total

userid128223 — Thu, 29 Nov 2012 17:01:55 GMT

That will hide entire field, which I dont want to do. I want Time Remaining field to be displayed however hide the calculation in that field for individual column and only show sub totals displayed for company.

thanks

Re: hide column data but show total

IAMDV — Thu, 29 Nov 2012 18:39:19 GMT

Please post your QVW file with Stefan's example and we'll mock up an example for you.

Thanks,