Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

% by month

Good morning,

Please, could someone help me with this scripting:

I i put this expresions:

1)  Number

( distinct CSQUEST_ID)

2)%:

({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total distinct CSQUEST_ID)

I get this table:

                                                                   

YEAR_MONTH2013/062013/062013/072013/07
Age RangeNumber%Number%
18-24871,7%1422,8%
25-343937,7%62712,2%
35-443777,3%77915,2%
45-544057,9%87817,1%
55-644298,4%4789,3%
65-742695,2%2023,9%
75 or more370,7%310,6%

The issue is that what i want to get is this table: ( A percentage of the month)

   

YEAR_MONTH2013/062013/062013/072013/07
Age RangeNumber%Number%
18-24874,4%1424,5%
25-3439319,7%62720,0%
35-4437718,9%77924,8%
45-5440520,3%87828,0%
55-6442921,5%47815,2%
65-7426913,5%2026,4%
75 or more371,9%31

1,0%

Is this possible?? Thanks a lot!

Belén

1 Solution

Accepted Solutions
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Try this.


({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total <YEAR_MONTH> distinct CSQUEST_ID)

View solution in original post

6 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Try this.


({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total <YEAR_MONTH> distinct CSQUEST_ID)

Not applicable
Author

Try with total <Month> in the second part of your expression

Fabrice

Not applicable
Author

Thanks a lot! it Works!

You are so nice!

Not applicable
Author

Excellent

Tag Nilesh's answer as correct then

Fabrice

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Please mark the answer as correct.

-Nilesh

nilesh_gangurde
Partner - Specialist
Partner - Specialist

Thanks Fabrice.

-Nilesh