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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Straight Table Issue

Hello,

I have table like below

LOAD * INLINE [

    Country, Sales

  India,  5000

  Us, 2500

  Uk, 4000

  India, 5000

  Us, 5500

  India, 4500

];

So, Now i want to show Straight table like below

CountrySales
India5000
India5000

Note: Please send me the Expression using Set Analysis ....

Please help me, I Appreciate your Help ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
11 Replies
qlikview979
Specialist
Specialist

Try like this

sum({<Country={'India'}>}Sales)

tamilarasu
Champion
Champion

Anil,

Sorry for the late reply, I was busy with work. Please check new attachment.