Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to remove Top 3 row where sales > 0 from my Table ?

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

9 Replies
paulyeo11
Master
Master
Author

my qvw

MK_QSL
MVP
MVP

FYI

paulyeo11
Master
Master
Author

Hi Manish

wOW after look at your 2 expression , it is more difficult then i though.

Thank you very much

Paul

paulyeo11
Master
Master
Author

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

MK_QSL
MVP
MVP

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

paulyeo11
Master
Master
Author

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

paulyeo11
Master
Master
Author

Hi Sir

In case you free can you pls help me ?

Sent from my iPhone

MK_QSL
MVP
MVP

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.

paulyeo11
Master
Master
Author

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