With a Qlik Sense Pivot chart you can do this:
The "Background Color Expression" would be:
The load script to give the two dimensions C# and R# for a row and column number would look like this:
Mod(ID-1,8)+1 AS C#,
Floor((ID-1)/8)+1 AS R#
ID , Adet
this look simple and lean for me but, for the workers it should be more visual, that's why i was trying to use the extension. There are more than 100 shelf's like this and we will need a lot of from this table. The user will everytime change the value if the shelf is loaded, later the automatisation will follow, which there will be sensors on the shelfs, that will send 0 and 1 to the database.
This was just a brainstorming result. We 'll see what we can do.
I'll try to make the staff accept this, if i cant find a solution with the extension and make it simple.
this is the top view of one warehouse area. We will need a front view for every set of 8x4 shelfs. And the data here will be entered using excel(from database in the future). Then when i open the app at qlik sense i'll use update button to fetch new data and change visual.
the thing with the svg extension is, every square has an id like " svgid_1" in our example. But in reality the shelfs has their own uniqe id's in the database which i have no access now. The reason i wanted to use svg reader is i will try to match the real id of the shelf with the right square on the screen and use color function. Actually It would be better not to use the extension, but it seemed simple to make at first glance.