Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Hi Milda!

I've tried to make a table, which shows last items (lowest sales). What i've changed: I have added minus (-) sign in calculated dimension. But I don't know if this will be ok for you. --> Yes, I saw the minus(-) sign.

Go to the "Last top" tab. There I've created 2 similar tables. The only difference is that in the first table expression I've added +1. --> I could not see where you have added +1 in the first table expression. There is a strange thing: for example, when you select Year 2009, in the second table you will see that "item no" begins from 76. The reason: there are 75 items with 0 sales (in 2008). --> I want the item no begins from 1 where the least comes first and then so on. I think it's better to ignore the zero's and show only those items where sales value is there.

I want to have the same thing as it is in the top tab. But instead of top i want the last. I need all the four tables like that.

Thanks for your effort!

Regards,

Rikab

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Look at the picture:

Highlighted
Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Yes saw it only after posting it.. Requesting to check rest of the things. I need the same one what was there in the Top tab.

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

I've created one more tab "Last top100" (similar to Top tab).

But the problem still exists: you can't see the items which sales=0. For this reason I've made Last TOP100 (instead of Last TOP10).

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Hi Milda!

I think you have missed out my last reply for your post. Anyway have added it again below.

What we will do is better to ignore the items with sales value=0 and show only those items with sale value more that 0. In that case i think it should be possible. One more important thing which i want i the ranking. The ranking no should start from 1 and then so on. Because in your document it starts from different numbers.

~~~~~~~~~~~~~~~~~~~~~~

There is a strange thing: for example, when you select Year 2009, in the second table you will see that "item no" begins from 76. The reason: there are 75 items with 0 sales (in 2008). --> I want the item no begins from 1 where the least comes first and then so on. I think it's better to ignore the zero's and show only those items where sales value is there.

I want to have the same thing as it is in the top tab. But instead of top i want the last. I need all the four tables like that.

Thanks for your effort!

Regards,

Rikab

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Hi Milda!

Sorry to disturb you again! Did you worked around on this again? If you have got any other solution please do let me know.

Thanks and Regards,

Rikab

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Hi Rikab,

I still don't know how to skip zero (0) values and start numbering from 1. If I find the solution, I will tell you Smiley Happy

Milda

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Ok fine... I am also checking with different logic... Will let you know if it works out...

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Hi Rikab, I have found the solution. But I can't attach the file. So maybe you can give me your email address?

Not applicable

Top 100 Customer who are there in previous Year not in Current Year

Gr8 thankyou... Please take down my email id... rikab@c2info.com Waiting for your mail!

Community Browser