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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
MVP
MVP

How to create summary from attached data module

Dear All,

I have following data model , Which is linked with cost centers using qualify we have attached more than 20 opportunity like this now here my requirement is create a summary like this

Opportunity            Charges

-------------------       ----------------

Opportunity1          545.1

Opportunity2           538.

.

.

.

-------------------------------------

Total                      1083.1

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Labels (1)
16 Replies
varshavig12
Specialist
Specialist

Create a flag

sunny_talwar
MVP
MVP

You want it in a straight table?

varshavig12
Specialist
Specialist

Try this.

sunny_talwar
MVP
MVP

Like this?

Capture.PNG

varshavig12
Specialist
Specialist

You want the same data model ?

vikasmahajan
MVP
MVP
Author

yes want in straight table

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan
MVP
MVP
Author

Thanks Sunny , Actually in dimension i want  opportunity and  in expression sum(Charges) this is only one filed in demo data but i have to define 3 more with expression .

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
sunny_talwar
MVP
MVP

Then look at what Varsha has provided below

vikasmahajan
MVP
MVP
Author

Thanks Varsha like sunny given i want  but  in dimension i want opportunity i.e opportunity1 , opportunity2

and in expression  sum( ) of each opportunity.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.