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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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.