Need Expression For Table

[msbhuvanesh003]

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.

[Lisa_P]

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

[msbhuvanesh003]

Hi,

platform: Qlik Sense

If its possible make this using expressions.

[kaanerisen]

Hi,

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

[agastya · Accepted solution]

Hi

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

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

[msbhuvanesh003]

Thanks a Lot @axn

[msbhuvanesh003]

Thanks a Lot kaanerisen‌

[msbhuvanesh003]

Thanks a Lot @vishal pujari

[Lisa_P]

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

[agastya]

hi lisa

sum(Total Txns ) expression also work