topic Re: filter dimension in QlikView

filter dimension

raadwiptec — Fri, 05 Feb 2016 11:46:28 GMT

Hi all,

I need to filter a dimension

For ex: Customer Id is the dimension

On the Chart I need to show only Customer Ids with 200 ,250,300,450

rest should not be shown and should be hided ..it is a pivot chart and customer id is on the horizontal line

Re: filter dimension

MK_QSL — Fri, 05 Feb 2016 11:47:53 GMT

You can use Set Analysis for that

Something like below

Dimension

[Customer Id]

Expression

SUM({<[Customer Id] = {'200','250','300','450'}>}Sales)

Re: filter dimension

raadwiptec — Fri, 05 Feb 2016 11:50:36 GMT

it is a dimension ..not an expression ..

Re: filter dimension

Fri, 05 Feb 2016 11:55:54 GMT

Hi ,

You can use if(match(Customer Id,200 ,250,300,450),Customer Id) in dimension and suppress the nulls in the dimension

Regards

Re: filter dimension

MK_QSL — Fri, 05 Feb 2016 11:59:01 GMT

I have given expression which is limiting dimension...

If you don't want to use set analysis in expression, use below as calculated dimension in dimension tab

IF(Match([Customer Id],'200','250','300','450'),[Customer Id])

Tick suppress when value is null in dimension tab for this dimension

Re: filter dimension

vardhancse — Fri, 05 Feb 2016 11:59:49 GMT

in expression if we restrict the dimension values, then we will see only given dimension values

Re: filter dimension

MK_QSL — Fri, 05 Feb 2016 12:01:15 GMT

This is what your question is about..

Chart I need to show only Customer Ids with 200 ,250,300,450

rest should not be shown and should be hided

Re: filter dimension

raadwiptec — Fri, 05 Feb 2016 12:04:56 GMT

yes manish this is good

Re: filter dimension

MK_QSL — Fri, 05 Feb 2016 12:08:25 GMT

if problem solved... pls close the thread.. THNX

Re: filter dimension

avinashelite — Fri, 05 Feb 2016 12:14:01 GMT

try like this

in the dimension

if([Customer Id]=200 or [Customer Id]=250 or [Customer Id]=300 or [Customer Id]=450,[Customer Id])

Supress null in the dimension

ADD the [Customer Id] as the dimension and in the expression

SUM({<[Customer Id] = {'200','250','300','450'}>}Amount)

Re: filter dimension

raadwiptec — Fri, 05 Feb 2016 15:09:04 GMT

Can I also put the same concept for if then condition

for ex in the calculated dimension

if (customer id = 300 ,'Low' ,

so for multiple conditions how can we do it

Re: filter dimension

sathishkumar_go — Fri, 05 Feb 2016 15:18:20 GMT

for multiple condition, use have to use nested if.

example:

if (customer id = 300 ,'Low' ,

customer id = 200 ,'High' ,Medium)

-Sathish

Re: filter dimension

raadwiptec — Fri, 05 Feb 2016 15:23:33 GMT

no this does work it is giving error

Re: filter dimension

sathishkumar_go — Fri, 05 Feb 2016 15:28:35 GMT

Sorry. use this

if (customer id = 300 ,'Low' ,

if(customer id = 200 ,'High' ,'Medium'))

Re: filter dimension

MK_QSL — Fri, 05 Feb 2016 15:45:19 GMT

You are struggling to get a correct answer since 4 hours which seems to be very easy.

If you provide sample data or sample application, you can have your answer within 10 mins..