topic Re: Issue with Partial Sum Dynamic Label in QlikView

Issue with Partial Sum Dynamic Label

Thu, 03 Apr 2014 11:19:08 GMT

Hello All,

Let me summaries my requirement.

I have pivot with 2 columns value and 1 row value, I want to make my label dynamic which changes in the List selection for the partial sum (for row), which I can do with Expression.

but it works only when I expand the data and goes back to TOTAL(Default) if I collapse it.

Can someone please help me how to solve my issue. Attaches in the sample qvw file.

Thanks & Regards,

MVV Satish.

Re: Issue with Partial Sum Dynamic Label

MK_QSL — Thu, 03 Apr 2014 11:23:36 GMT

Properties >> Presentation >> Select FQ and >> Labels for Totals >> =GetFieldSelections(List)

Re: Issue with Partial Sum Dynamic Label

its_anandrjs — Thu, 03 Apr 2014 11:39:19 GMT

Go to

Properties -> Presentation -> Select FQ Dimension -> Labels for Totals -> type a code

=if(GetSelectedCount(List)=1,GetFieldSelections(List),'Total')

because when you not select any thing it display '-'

Re: Issue with Partial Sum Dynamic Label

Thu, 03 Apr 2014 12:04:48 GMT

Thanks for the suggestion, but I don't want to change the label for the FQ

Re: Issue with Partial Sum Dynamic Label

Thu, 03 Apr 2014 12:05:20 GMT

Thanks for the suggestion, but I don't want to change the label for the FQ

Re: Issue with Partial Sum Dynamic Label

its_anandrjs — Thu, 03 Apr 2014 12:09:02 GMT

For which column you required.

Re: Issue with Partial Sum Dynamic Label

nizamsha — Thu, 03 Apr 2014 12:19:20 GMT

PFA

Re: Issue with Partial Sum Dynamic Label

Thu, 03 Apr 2014 13:18:45 GMT

For Country Column