topic Re: IF AND ELSE IF in QlikView

IF AND ELSE IF

Mon, 22 Dec 2014 13:15:26 GMT

HI ALL,

I HAVE AN EXPRESSION IN MY TABLE like below

if(T1_Group = ('1A' or'2A') and T1.Period < 201408 ,Sum(T2.revenue),Sum(t1.revenue))

hear T2.revenue is displaying the results only corresponding group of i.e where t2.Group = ('1A' or'2A'))

Currently the results are showing incorrectly for the above expression can anybody correct me

T1--Table 1

T2---Table 2

Re: IF AND ELSE IF

rajeshvaswani77 — Mon, 22 Dec 2014 13:20:07 GMT

Hi Kishore,

Can you post an example?

thanks,

Rajesh Vaswani

Re: IF AND ELSE IF

Anonymous — Mon, 22 Dec 2014 13:21:50 GMT

Try this :

if((T1_Group = '1A' or T1_Group ='2A') and T1.Period < 201408 ,Sum(T2.revenue),Sum(t1.revenue))

Re: IF AND ELSE IF

yevgeniy — Mon, 22 Dec 2014 13:35:11 GMT

Hi Kishore,

Try this:

if(T1_Group = ('1A') and T1.Period < 201408,Sum(T2.revenue),

if(T1_Group = ('2A') and T1.Period < 201408,Sum(T2.revenue),

Sum(t1.revenue)))

Re: IF AND ELSE IF

Mon, 22 Dec 2014 13:38:45 GMT

Hi,

i am displaying T1 pivot table.

Table1 (T1):

Jan2014 Feb2014................................

Material Group | Group Events Revenue Revenue ...............................

Mg1 1A Event1 200 100

Event2 200 300

Event3 300 400

2A Event1 100 500

Event4 100 600

while Collapse with only Group in my Pivot Table results are expecting in T1 table like Jan 600 and Feb 400 for Group 1A based on condition success ......if failed cases(where period >201408) results are aggregated like 700 in Group 1A as like above..

There is no Event Dimension in the T2 table ..

Table2(T2):

Jan2014 Feb2014

Material Group | Group Revenue Revenue

Mg1 1A 600 400

2A 500 600

Can you help on this

Re: IF AND ELSE IF

yevgeniy — Mon, 22 Dec 2014 14:09:16 GMT

May be problem is, aggr

your need change Sum(T2.revenue), try this:

aggr(Sum(T2.revenue),Group,Period)

Re: IF AND ELSE IF

Tue, 23 Dec 2014 10:10:32 GMT

Hi, Yevgeniy

The above solution working when individual selections applied on the Pivot table...But not whole table why?

when i clear the selections it showing original Table1 Expression Values can you address the issue

Thanks.

Re: IF AND ELSE IF

yevgeniy — Tue, 23 Dec 2014 13:21:26 GMT

May be you tables have null values?

Re: IF AND ELSE IF

Tue, 23 Dec 2014 16:10:52 GMT

yes i have null values in my table i tried supress null values by dimension wise

same result subtotals not working