Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Straight Table not affected by more than one selection

Hi

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))

1 Solution

Accepted Solutions
sujeetsingh
Honored Contributor III

Re: Straight Table not affected by more than one selection

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,

10 Replies
sujeetsingh
Honored Contributor III

Re: Straight Table not affected by more than one selection

May be this will work

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

[Order Quantity Backordered]*

[Component Qty],0))

Not applicable

Re: Straight Table not affected by more than one selection

Hi Sujeet

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

kind regards

Nayan

sujeetsingh
Honored Contributor III

Re: Straight Table not affected by more than one selection

can you give a sample

?

Not applicable

Re: Straight Table not affected by more than one selection

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

Module.jpg

sujeetsingh
Honored Contributor III

Re: Straight Table not affected by more than one selection

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,

er_mohit
Honored Contributor II

Re: Straight Table not affected by more than one selection

Try this

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

[Order Quantity Backordered]*

[Component Qty],0))

Not applicable

Re: Straight Table not affected by more than one selection


Hi Sujeet

Thank you .  It worked.  Much appreciated.

kind regards

Nayan

Not applicable

Re: Straight Table not affected by more than one selection

Hi Mohit

Thank you.  Thats the formula i used.  It worked

kind regards

Nayan

er_mohit
Honored Contributor II

Re: Straight Table not affected by more than one selection

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

Community Browser