topic Re: create filter on Straight Table in QlikView

create filter on Straight Table

Anonymous — Fri, 23 May 2014 14:20:19 GMT

Hi All,

I have 4 types of Competency in data but what i want is to see only there and want to restrict one(i.e _Total).

Please find attached .qvw

Thanks

Manish Madan

m_woolf — Fri, 23 May 2014 14:25:14 GMT

For the Competency dimension, enter:

=if(commpetncy<>'_Total',commpetncy)

Then check Supress when value is null

Anonymous — Fri, 23 May 2014 14:40:31 GMT

Thanks Michael

Anonymous — Fri, 23 May 2014 14:45:40 GMT

A good practice is not to load the "total" at all. Just to filter it out in script by using this:

WHERE Competency <> '_Total'