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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
SupriyaEllgode
Contributor
Contributor

How to group data in Stright table

SupriyaEllgode_0-1721368187452.png

I want region name should be printed once in first column and in second column its related district.

Please help me out to solve this .

Thank you

 

Labels (1)
1 Reply
rubenmarin

Hi, I'm not sur e of the needs but I think you can solve them using Above(), like:

If(Region<>Above(TOTAL Region), [Expression])

So it only calculates the expression when region is different from the row above.