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

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

paulyeo11 — Thu, 23 Jun 2016 13:23:13 GMT

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

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

paulyeo11 — Thu, 23 Jun 2016 13:26:41 GMT

my qvw

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

MK_QSL — Thu, 23 Jun 2016 13:48:04 GMT

FYI

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

paulyeo11 — Thu, 23 Jun 2016 14:01:54 GMT

Hi Manish

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

Thank you very much

Paul

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

paulyeo11 — Thu, 23 Jun 2016 14:40:27 GMT

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 ?

MK_QSL — Thu, 23 Jun 2016 14:58:34 GMT

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

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

paulyeo11 — Thu, 23 Jun 2016 15:17:52 GMT

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

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

paulyeo11 — Sat, 25 Jun 2016 06:25:11 GMT

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 ?

MK_QSL — Sat, 25 Jun 2016 07:05:55 GMT

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.

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

paulyeo11 — Sat, 25 Jun 2016 08:53:09 GMT

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