Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor

Re: % by month

Try this.


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

6 Replies
nilesh_gangurde
Valued Contributor

Re: % by month

Try this.


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

Not applicable

Re: % by month

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

Fabrice

Not applicable

Re: % by month

Thanks a lot! it Works!

You are so nice!

Not applicable

Re: % by month

Excellent

Tag Nilesh's answer as correct then

Fabrice

nilesh_gangurde
Valued Contributor

Re: % by month

Please mark the answer as correct.

-Nilesh

nilesh_gangurde
Valued Contributor

Re: % by month

Thanks Fabrice.

-Nilesh