I have a table 1 with 18 row , i need to remove top 3 row , where the sales amount > 0. As i want to make the table only list sales =0.
I have try on table 2 , i manage to remove only YTD value , but unable to remove the row.
Hope some one can share with me.
Solved! Go to Solution.
After you successfully help me on sales decline listing to break into 2 table.
Now I have another list , which is sales increase listing table 1 Row 1 to 6 into Table 2
when i try to follow the same approach , I manage to display 3 company only . i miss out 3 company. not sure why ?
For new customer listing. Table 3., i try to filter Row 6 till 24 from Table 1 , i try to follow the same approach , but i still stuggle with it. Hope you can advise me.
Thank you very much. I have already create a new post . By the way you now in Whicb country ?
Sent from my iPhone
I will try but need to understand what your requirement is.
Can you attach required output in excel here?
I am outside home and don't have access of QlikView so will reply back to you later today.
Hi Manish i have create the report i expected in excel on above link.
wish you have a nice week end.