topic conditional label for subtotal in QlikView

conditional label for subtotal

Sun, 23 Mar 2014 17:41:53 GMT

Hi All,

I have an application where I have a pivot table ,is it possible to put a conditional subtotal(ie..label names) for pivot table.

Thanks & Regards,

Reena Abraham

Re: conditional label for subtotal

srchilukoori — Sun, 23 Mar 2014 19:51:10 GMT

you can write expressions in the labels fields for each individual dimension on the pivot tables.

Re: conditional label for subtotal

Mon, 24 Mar 2014 05:51:00 GMT

Hi,

I have tried that but it is only working with selections. Without Selection its showing only Total ,not evaluating the Expression.

Thanks,

Reena

Re: conditional label for subtotal

Mon, 24 Mar 2014 05:59:07 GMT

its only work on selection.

If you want to show without selection, write in the script like 'If(GetSelectedCount(currency)=0,'All',GetFieldSelections(currency))'

Hope you understand

Re: conditional label for subtotal

Mon, 24 Mar 2014 06:09:37 GMT

Hi,

I had given the expression on Presentation Tab, for labels for Total. Hope you have mean that. Then also its working with selections. else its showing as 'All' based on the expression.

I need to show without selections dynamic labels.

Thnkss...

Re: conditional label for subtotal

Mon, 24 Mar 2014 07:31:03 GMT

Can you share your app. then i will work on it for you

Re: conditional label for subtotal

srchilukoori — Mon, 24 Mar 2014 12:56:13 GMT

You need to check the option "always one selected value" on the currency field.