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: 
Anonymous
Not applicable

Is it possible to "freeze/lock" selections and use the freezed selection in another pivottable to show all data?

Hi

This is a little difficult to explain but I will try.. The thing that i'm trying to do is this.

First select top 25 articles based on sales for the whole data (company). Then I would like to see how this 25 articles are sold in a Region. Which salesreps are not selling the top 25 articles? But when I make the selection in the field Region with REG04. it will show only 21 articles in the pivottable. But I have made a selection of 25 articles.?

The reason for this that the region REG04 has not sold all of the 25 articles. 4 articles are not sold at all. I would like in to e to find this 4 articles. And also have this 4 articles in a different color or format.

I would like to have this as a dynamic solution. Somtetimes it's top 50 articles based on BusinessArea. Somtimes top 10 articles based on the sales of Bill and so on.

Any suggestions? Alternating state? A datamodel with the salesdata in two different tables that not are connected? Aggr-functions?

I have attached a sample qvw-file and also excelfile with sample data.

Best regareds

Peter

topsales.png

2 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi Bergman,

Well, I tried a lot front-end methods to try to solve this in front-end. All failed...

So maybe there is some methods I don't know.

But I know there is a way can show the 25 articles... do the Cartesian, but it's not a good way I think, especially if you have too large data.

So I'm thinking whether you must do the request in the dashboard. Because it seems like the design of qlikview is just not showing the unassociate data.

Below is the attachment you can see.

Sorry I didn't find a way to highlight the 0 column, except do the Cartesian again...


Thanks.

Aiolos

Anonymous
Not applicable
Author

Hi Aiolos

Thank you for your input. I can see that you have used left join in the script and by doing that you will create new records for the null / missing rows when joining the other data . That could be a possible solution. In the real application I'm developing it's more data and more fields. I will try this with left joins and see what happens with the performance of the real application. Maybee it will solve the issue.


Thank you again


Best regards

Peter