Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Limit fields in dimension

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

1 Solution

Accepted Solutions

Re: Limit fields in dimension

Try this,

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

Regards,

Kaushik Solanki

View solution in original post

5 Replies

Re: Limit fields in dimension

Hi,

     You can use the calculated dimension such as

     if(Field <> 'Total',Field)

Regards,

Kaushik Solanki

Not applicable

Re: Limit fields in dimension

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?

Not applicable

Re: Limit fields in dimension

Got it, I suppressed the null values.

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

Re: Limit fields in dimension

Try this,

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

Regards,

Kaushik Solanki

View solution in original post

Not applicable

Re: Limit fields in dimension

Magical. Thank you for your help