Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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))

10 Replies
Not applicable
Author

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