Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total in Straight table row wise

Hi,

I have a straight table where i want to show Row wise Total.

In Dim i have few strings like

Dim                                  Expr(Count)

Product1 Source                    55

Product2 Source                  150

Product Target                       10

Product1 Target                      25

Product2 Target                      25

Product3 Source                     30

What i want is Just two fields in Dim and Expr as

Dim                        Total

Source                    235

Target                       60

I used set analysis though but not getting what i expect..

Thanks.

16 Replies
Not applicable
Author

hi gtripathy,

can u please explain your Question more briefly So can Help u Quickly

alexandros17
Partner - Champion III
Partner - Champion III

here is an example

arsal_90
Creator III
Creator III

Can u just provide the sample data then i will make a sample document for u

PrashantSangle

Hi,

Create Straight Table ,

Use Dimension as,

=if(WildMatch(Dim,'*Target'),'Target','Source')

And Expression as Sum(Count)

For Better understanding I am attaching application.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sunilkumarqv
Specialist II
Specialist II

Use below Expression as your calculated dimension instead of Dim (Original)then label it as Dim

=If(index(Dim,'Source'), 'Source', 'Target')

Not applicable
Author

Hi All,

Sorry if i couln't explain the req properly.

I'm showing counts of Source and Target for Product1,Product2...etc like below

Product1 Source                    55

Product2 Source                  150

Product Target                       10

Product1 Target                      25

Product2 Target                      25

Product3 Source                     30

What i want is Just to display Source and Target  (Where Source ll show the Total of Product1 Source,Product2 Source.. i,e all Product source) and likewise Target ll show Total of all Target Products.

Anonymous
Not applicable
Author

well in your case solution given by max dreamer should work have you tried ?

anant

PrashantSangle

Hi,

Can you provide sample data with proper dim data so that we can work on it

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

=if(WildMatch([product Name],'*Source*'),'Source', if(WildMatch([product Name],'*Target*'),'Target'))

I'm using this expression but don't know why don't i see Target??