Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table as pictured below with the Product as the row and year and country as columns and sum(sales) as the measure.
The user is asking for a line when the year changes so that they can easily distinguish where the year changes. I found no option to do that. I did try adding a blank column with the background color set to Red but Qlik makes it as wide as the other column.
Are there any other techniques to do this? I am actually using the vizlib pivot extension, but no luck there either.
Sample data for a pivot table if it helps!
load * inline [
Product,country,year,sale
Cycle,USA,2022,10
Cycle,USA,2023,20
Car,India,2022,5
Car,India,2023,10
];
exit Script;
Hi Pravin,
You can try giving alternating background colour to the Year Cells so that can also help distinguish the years. Alternatively you can try the below extension, here you can create your desired output with minor tweaks.
https://github.com/ajaykakkar93/TableBox
Credits : @ajaykakkar93
Regards,
Rohan.