topic Re: Exclusion on dimension in QlikView

Exclusion on dimension

Fri, 19 Jun 2015 15:49:53 GMT

Hi Experts,

I have a pivot table with dimensions branch name, branch no. and some sales expressions.

there are around 200 branches and i need to exclude some 10 branch codes in the dimensions.

how can i do that.

plss help

sunny_talwar — Fri, 19 Jun 2015 15:54:19 GMT

Try this:

If(not Match([branch name], 'branch1', 'branch2', ....), [branch name])

sunny_talwar — Fri, 19 Jun 2015 15:56:05 GMT

If(not Match([branch no.], 'branchCode1', 'branchCode2', ....), [branch name])

use whichever dimension you want to use for exclusion of branches.

HTH

Best,

Sunny

giakoum — Fri, 19 Jun 2015 15:56:38 GMT

or set up a flag in your reload script so that you don't have it hard-coded in your application expressions

buzzy996 — Fri, 19 Jun 2015 15:57:43 GMT

soem thing like,

=sum({<branches-={list down all brances whcihevvr u have exclued,like '101','102'..etc}>}sales)