Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

saadzaman
New Contributor III

Individual Month Percentages

Hi All,

I am actually struggling to get the %age for individual months

My Measure looks like:

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'},MonthYear>}[XXX])

I have also tried below :

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL {<ABC-={'181 and Above'},DEF={'APPROVED'}>}MonthYear[XXX])

But this does not give any result.

Regards,

Saad

1 Solution

Accepted Solutions

Re: Individual Month Percentages

May be this

Sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX]) /

Sum(TOTAL <MonthYear> {<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

9 Replies
YoussefBelloum
Esteemed Contributor

Re: Individual Month Percentages

Hi,

attach sample data and what you expect to have on the %age

saadzaman
New Contributor III

Re: Individual Month Percentages

HI ,

I have attached sample data in the post and also I am attaching here:

I want individual month percentages to be shown as in below table.

Sample Data

Description

Jan-2017

Feb-2017

Mar-2017

AAA

40.88%

38.52%

28.52%

BBB

18.86%

15.57%

13.57%

CCC

9.86%

9.86%

10.86%

DDD

5.24%

5.24%

8.24%

EEE

4.26%

4.26%

6.26%

FFF

4.52%

4.88%

5.88%

GGG

3.38%

3.38%

5.38%

HHH

2.45%

2.45%

3.45%

III

5.68%

5.68%

3.68%

JJJ

2.78%

2.78%

2.78%

KKK

0.57%

1.86%

1.86%

LLL

0.54%

1.54%

1.54%

MMM

0.36%

1.36%

1.36%

NNN

0.23%

1.23%

1.23%

OOO

0.14%

1.14%

1.14%

PPP

0.12%

0.12%

1.12%

QQQ

0.03%

0.03%

1.03%

RRR

0.06%

0.06%

1.06%

SSS

0.02%

0.02%

1.02%

YoussefBelloum
Esteemed Contributor

Re: Individual Month Percentages

You didn't attach nothing on the document, and for the data you posted here, try to sctructure it to be able to use it

saadzaman
New Contributor III

Re: Individual Month Percentages

Hi,

I have attached an .xls file, same is attached here.

Regards,

Saad Zaman

OmarBenSalem
Esteemed Contributor

Re: Individual Month Percentages

Can u try :

sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

/

Sum (TOTAL <ABC-={'181 and Above'},DEF={'APPROVED'},MonthYear> * <MonthYear>[XXX])

Re: Individual Month Percentages

May be this

Sum({<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX]) /

Sum(TOTAL <MonthYear> {<ABC-={'181 and Above'},DEF={'APPROVED'}>}[XXX])

saadzaman
New Contributor III

Re: Individual Month Percentages

Hi Omar,

This gives syntax error.

Regards,

Saad

saadzaman
New Contributor III

Re: Individual Month Percentages

Hi Sunny,

This is perfect.

Thanks a lot for your help.

Regards,

Saad Zaman

OmarBenSalem
Esteemed Contributor

Re: Individual Month Percentages

That's what I wanted to do with a slight syntax error

Community Browser