Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
msbhuvanesh003
Contributor III
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.

  

Group20162017
Fin164,336 617,550
Xm86,705 62,723
Total251,041 680,273

How to split the Txn Count using Expression in table.

kindly help me for this.

1 Solution

Accepted Solutions
agastya
Creator
Creator

Hi

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

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

View solution in original post

9 Replies
Lisa_P
Employee
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

QV.PNG

Qlik Sense

QS.PNG

msbhuvanesh003
Contributor III
Contributor III
Author

Hi,

platform: Qlik Sense

If its possible make this using expressions.

kaanerisen
Creator III
Creator III

Hi,

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

agastya
Creator
Creator

Hi

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

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

msbhuvanesh003
Contributor III
Contributor III
Author

Thanks a Lot @axn

msbhuvanesh003
Contributor III
Contributor III
Author

Thanks a Lot kaanerisen

msbhuvanesh003
Contributor III
Contributor III
Author

Thanks a Lot @vishal pujari

Lisa_P
Employee
Employee

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

agastya
Creator
Creator

hi lisa

sum(Total Txns ) expression also work