Discussion board where members can get started with QlikView.
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?
if(not wildmatch(Field,'Total','Sub total'),Field)
View solution in original post
You can use the calculated dimension such as
if(Field <> 'Total',Field)
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?
Got it, I suppressed the null values.
How can I put multiple in there? Such as Total and Subtotal?
Magical. Thank you for your help