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: 
Monkeyb33f
Contributor II
Contributor II

Concatenate Dimensions then Separate in chart to Cycle Throug

Hi All,

I have a scenario where that I'm not sure is possible but thought to reach out to the experts to check. I have a dashboard where a client would like to report out using nPrinting, which is fine. However, we have a data set that shows stockist across several dimensions as so:

 

ProductSalesCostStockist1Stockist2Stockist3
Product A50$5Shop1Shop2 
Product B25$15Shop2 Shop3
Product C60$25Shop2Shop3 

 

Essentially, they want the Stockist field(s) to be the key dimension, so the requirement would be to group all of the information from the three fields and then show the information as follows - note that the sales and cost can repeat:

 

StockistProductSalesCost
Shop1Product A50$5
Shop2Product A50$5
Shop2Product B25$15
Shop2Product C60$25
Shop3Product B25$15
Shop3Product C60$25

 

If we can create the table as above, then I can use the 'new' Stockist field to cycle through in nPrinting. Just to make life a lot more awkward, this is an existing dashboard, so i will need to be careful on making too many changes to the data model or script.

Any advice or tips you can provide are gratefully received.

Labels (3)
1 Solution

Accepted Solutions
marcus_sommer

1 Reply
marcus_sommer

Take a look here: The-Crosstable-Load.

- Marcus