Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
dylannelson
New Contributor II

Populating Duplicate Using Dimensions

 

 

  Hello Team,

Really NEWWWW to QlikView. I'm currently trying to populate any SKU that has a duplicate. I've looked at multiple forms, and I've tested quite a few of them, and still no luck.

Qlikview.PNG

 

5 Replies
Marcos_rv
Contributor

Re: Populating Duplicate Using Dimensions


Hi how are you??
it is not a duplicate, because the "Active loc." has 3 values ​​for that SKU, you probably have a join where the relationship is not 1 to 1 between SKU and "ACTIVE LOC.", which you should check, or SKU is not your key field.

regards!!!

dylannelson
New Contributor II

Re: Populating Duplicate Using Dimensions

Hello Thanks for the quick response. So I believe I understand what you're saying. Here's the script to have a better idea of how the data is being imported. This is an excel sheet btw. Qlikview2.PNG

 

Marcos_rv
Contributor

Re: Populating Duplicate Using Dimensions


if it comes straight from a table, without having to go through a join before (linking tables), it means that you will not have a unique SKU record, it is not key, now if you are interested in obtaining only one record for each SKU, you should think of a criterion, this you should analyze. Stop being duplicated when at least one value in some non-key field is different from the others, in your case "Active Loc." has 3 different values ​​for an SKU.

Regards!!!

dylannelson
New Contributor II

Re: Populating Duplicate Using Dimensions

I defiantly want to show duplicates regardless of the Avitve Loc. Maybe this is a stupid question, but could I load the same table twice to generate two tables to keep the SKU as its on entity? Would this then be able to filter because it would no longer be associated in the same table?

Support
Support

Re: Populating Duplicate Using Dimensions

I am not so good at development myself, but I think maybe using the Peek() function to look at the next row value and checking if it matches the prior may be the way to go, and if you get a match, you load the record, otherwise you proceed to the next one.  Unfortunately I cannot give you an example, maybe someone else can run with things from here potentially.  

Cheers,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.