topic Re: Exclude Value in QlikView

Exclude Value

nihhalmca — Wed, 17 Sep 2014 13:06:49 GMT

Hi All,

Ex: I have Year, Reseller name and amount fields.

Year Reseller Amount

2012 A 100

2012 B 101

2012 C 102

2013 C 200

2013 D 201

2014 D 300

2014 E 301

When will i click year: 2014 it has to show only Reseller Name: E (I need to exclude Reseller Names which has already been in previous years.

Regards,

Nihhal.

Re: Exclude Value

MK_QSL — Wed, 17 Sep 2014 13:19:37 GMT

Temp:

Load *, 1 as Flag Inline

[

Year, Reseller, Amount

2012, A, 100

2012, B, 101

2012, C, 102

2013, C, 200

2013, D, 201

2014, D, 300

2014, E, 301

];

NoConcatenate

Final:

Load

Reseller,

Year,

Amount,

If(RowNo() = 1, 1, If(Reseller = Previous(Reseller),0,1)) as Flag

Resident Temp

Order By Reseller, Year;

Drop Table Temp;

Now use below as a List Box Expression or as a Text Box Expression

=Aggr(IF(Flag = '1', Reseller),Reseller,Year)

Re: Exclude Value

maxgro — Wed, 17 Sep 2014 19:56:26 GMT

try with a chart

2 dimensions

Year, Reseller

expression

sum({<Reseller=P({1<Year={$(=max(Year))}>} Reseller)>-<Reseller=P({1<Year={$(=max(Year)-1)}>} Reseller)>} Amount)

Re: Exclude Value

jagan — Thu, 18 Sep 2014 01:43:57 GMT

Hi Nihhal,

Try like this

Dimensions: Year, Reseller

Expression: =Sum({<Reseller=E({1<Year={'<$(=Max(Year))'}>})>} Amount)

Hope this helps you.

Regards,

Jagan.

Re: Exclude Value

nihhalmca — Fri, 19 Sep 2014 10:18:38 GMT

Thank you its working perfect. Just i used variable for dynamic instead of max(year).

Regards,

Nihhal.

Re: Exclude Value

nihhalmca — Fri, 19 Sep 2014 10:19:16 GMT

Thank you Jagan Mohan. its working. Just i used variable for dynamic instead of max(year).

Regards,

Nihhal.