Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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

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

FYI

9 Replies
paulyeo11
Valued Contributor II

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

my qvw

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

FYI

paulyeo11
Valued Contributor II

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

Hi Manish

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

Thank you very much

Paul

paulyeo11
Valued Contributor II

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

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

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

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
Valued Contributor II

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

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
Valued Contributor II

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

Hi Sir

In case you free can you pls help me ?

Sent from my iPhone

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

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
Valued Contributor II

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

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