Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

  

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
vishalpujari22
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
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

QV.PNG

Qlik Sense

QS.PNG

msbhuvanesh003
New Contributor II

Re: Need Expression For Table

Hi,

platform: Qlik Sense

If its possible make this using expressions.

kaanerisen
Contributor III

Re: Need Expression For Table

Hi,

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

vishalpujari22
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

msbhuvanesh003
New Contributor II

Re: Need Expression For Table

Thanks a Lot @axn

msbhuvanesh003
New Contributor II

Re: Need Expression For Table

Thanks a Lot kaanerisen

msbhuvanesh003
New Contributor II

Re: Need Expression For Table

Thanks a Lot @vishal pujari

Employee
Employee

Re: Need Expression For Table

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

vishalpujari22
New Contributor III

Re: Need Expression For Table

hi lisa

sum(Total Txns ) expression also work

Community Browser