Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Contributor III

## Need Expression For Table

Dear Expert,

i need a help. please find the attached Raw Data for your reference.

i have set of 2 years data. the raw data having Txn Count details in single (C) columns.

i want to show the total Txn year wise using table as per group.

Need output like this.

 Group 2016 2017 Fin 164,336 617,550 Xm 86,705 62,723 Total 251,041 680,273

How to split the Txn Count using Expression in table.

kindly help me for this.

1 Solution

Accepted Solutions
Creator

Hi

sum({<Group={'Fin'}>}[Total Txns]) Expression for Fin

sum({<Group={'Xm'}>}[Total Txns]) Expression for Fin

9 Replies
Employee

Hi,

Not sure if you are asking about QlikView or Qlik Sense, but works pretty much the same for both.

Create a Pivot table with Group and year as dimensions, add the sum of your txn as a measure and pivot year as a column to split out the years.  Should look like this ..

QlikView

Qlik Sense

Contributor III
Author

Hi,

platform: Qlik Sense

If its possible make this using expressions.

Creator III

Hi,

Sum({<Group-={'Total'}>}FIELDNAME)

Creator

Hi

sum({<Group={'Fin'}>}[Total Txns]) Expression for Fin

sum({<Group={'Xm'}>}[Total Txns]) Expression for Fin

Contributor III
Author

Thanks a Lot @axn

Contributor III
Author

Thanks a Lot kaanerisen

Contributor III
Author

Thanks a Lot @vishal pujari

Employee

for my chart above, only require Sum(Total Txns)

Creator

hi lisa

sum(Total Txns ) expression also work