Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Neo
Partner - Contributor
Partner - Contributor

Qlikview

Hello, I have multiple group segment each with designated stores. I want to calculate the percentage of store that had a positive growth from last year to current year for each group segment  e.g. Corporate Segment has 10 store in total, 7 stores had positive growth in 2020 so 70% outlet growth. Now I want to present this in a chat showing only Group Segment and outlet growth per segment (Calculation is based on stores but I don’t want to show store in the table/dimension) i.e.

Group SegmentSales 2019/2020Sales 2018/2019Growth 2019/2020Outlet Growth
Corporate1 358 0412 932 912-54%63%
Corporate Budget3 673 9261 569 143134%100%
Hyper595 0551 097 352-46%38%
Mini Market143 10592 79254%75%
Family11 839 9477 082 04867%54%
Family Budget4 286 2211 535 568179%100%
Total21 896 29514 309 81453%66%
Labels (1)
0 Replies