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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.