topic Re: Straight Table not affected by more than one selection in QlikView

Straight Table not affected by more than one selection

Fri, 20 Sep 2013 07:43:07 GMT

I have a formula below that works, where its not affected by [Cust Group] selection.

I now want to add to this formula that will also not be affected by [Module] selection.

How do i add this to the formaula.

kind regards

Nayan

sum({<[Cust Group] => } if(MonthIndex >= ( vMaxMonthIndex -1) and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

Re: Straight Table not affected by more than one selection

sujeetsingh — Fri, 20 Sep 2013 08:08:57 GMT

May be this will work

sum({<[Cust Group] =>,<[Module] => } if(MonthIndex >= ( vMaxMonthIndex -1) and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

Re: Straight Table not affected by more than one selection

Fri, 20 Sep 2013 08:18:58 GMT

Hi Sujeet

Thanks. However it does not work. As soon as you type the comma after => , the red underline appears.

kind regards

Nayan

Re: Straight Table not affected by more than one selection

sujeetsingh — Fri, 20 Sep 2013 08:23:11 GMT

can you give a sample

Re: Straight Table not affected by more than one selection

Fri, 20 Sep 2013 08:45:14 GMT

Hi Sujeet

In my [Module] list box , there are 2 variables . Order Entry and Acc.Receiv . (see below list box)

So , when I select Order Entry, it should not affect my value above.

I know its not a sample, but will this help.

kind regards

Nayan

Re: Straight Table not affected by more than one selection

sujeetsingh — Fri, 20 Sep 2013 08:57:23 GMT

Seee this sample here i have not used the same expression but yes made the expression as not to have any affect from selection in Module and CustGroup.

Hope it help,

Re: Straight Table not affected by more than one selection

er_mohit — Fri, 20 Sep 2013 09:00:49 GMT

Try this

sum({<[Cust Group] =, [Module]=> } if(MonthIndex >= ( vMaxMonthIndex -1) and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

Re: Straight Table not affected by more than one selection

Fri, 20 Sep 2013 09:04:16 GMT

Hi Sujeet

Thank you . It worked. Much appreciated.

kind regards

Nayan

Re: Straight Table not affected by more than one selection

Fri, 20 Sep 2013 09:07:04 GMT

Hi Mohit

Thank you. Thats the formula i used. It worked

kind regards

Nayan

Re: Straight Table not affected by more than one selection

er_mohit — Fri, 20 Sep 2013 10:06:19 GMT

if t helps you then mark it so it might be helpful for those developer which are using personal edition and others too

Re: Straight Table not affected by more than one selection

Fri, 20 Sep 2013 10:14:35 GMT

thanks. By this you mean mark it as correct answer. I have marked Sujeets post as correct answer.