# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
New Contributor III

## Re: Need Expression For Table

Hi

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

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

9 Replies
Employee

## Re: Need Expression For Table

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

New Contributor II

## Re: Need Expression For Table

Hi,

platform: Qlik Sense

If its possible make this using expressions.

Contributor III

## Re: Need Expression For Table

Hi,

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

New Contributor III

## Re: Need Expression For Table

Hi

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

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

New Contributor II

## Re: Need Expression For Table

Thanks a Lot @axn

New Contributor II

## Re: Need Expression For Table

Thanks a Lot kaanerisen

New Contributor II

## Re: Need Expression For Table

Thanks a Lot @vishal pujari

Employee

## Re: Need Expression For Table

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

New Contributor III

## Re: Need Expression For Table

hi lisa

sum(Total Txns ) expression also work