Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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.
Paul
my qvw
FYI
Hi Manish
wOW after look at your 2 expression , it is more difficult then i though.
Thank you very much
Paul
Hi Sir
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.
Paul
First advice is to create another question/thread.. I am on my way to home and in train so I can reply you after 1 hour..
Hi sir
Thank you very much. I have already create a new post . By the way you now in Whicb country ?
Paul
Sent from my iPhone
Hi Sir
In case you free can you pls help me ?
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.
How to list sales increase and new customer from sales increase list ?
Hi Manish i have create the report i expected in excel on above link.
wish you have a nice week end.
Paul