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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

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.
16 Replies
varshavig12
Specialist
Specialist

Create a flag

sunny_talwar

You want it in a straight table?

varshavig12
Specialist
Specialist

Try this.

sunny_talwar

Like this?

Capture.PNG

varshavig12
Specialist
Specialist

You want the same data model ?

vikasmahajan
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
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

Then look at what Varsha has provided below

vikasmahajan
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.