topic Re: Limit fields in dimension in QlikView

Limit fields in dimension

Thu, 29 Aug 2013 14:38:34 GMT

Hello all,

Within my data set, I have some groupings that are sub totals, is there a way to remove these from showing in some charts?

For example, I have a list including Sub Total and Total in a group, can I create a calculated field that removes those two?

With thanks,

Simon

kaushiknsolanki — Thu, 29 Aug 2013 14:43:45 GMT

Hi,

You can use the calculated dimension such as

if(Field <> 'Total',Field)

Regards,

Kaushik Solanki

Thu, 29 Aug 2013 14:49:44 GMT

Hi Kaushik,

I've given that a try, but it seems to have removed the name from the axis, but included the data under "-".

Any idea why?

Thu, 29 Aug 2013 14:51:20 GMT

Got it, I suppressed the null values.

How can I put multiple in there? Such as Total and Subtotal?

kaushiknsolanki — Thu, 29 Aug 2013 14:57:12 GMT

Try this,

if(not wildmatch(Field,'Total','Sub total'),Field)

Regards,

Kaushik Solanki

Thu, 29 Aug 2013 15:02:48 GMT

Magical. Thank you for your help