topic % by month in QlikView

% by month

Tue, 04 Feb 2014 09:36:57 GMT

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:

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

Is this possible?? Thanks a lot!

Belén

nilesh_gangurde — Tue, 04 Feb 2014 09:39:23 GMT

Try this.

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

Tue, 04 Feb 2014 09:39:49 GMT

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

Fabrice

Tue, 04 Feb 2014 09:53:17 GMT

Thanks a lot! it Works!

You are so nice!

Tue, 04 Feb 2014 10:06:24 GMT

Excellent

Tag Nilesh's answer as correct then

Fabrice

nilesh_gangurde — Tue, 04 Feb 2014 11:40:14 GMT

Please mark the answer as correct.

-Nilesh

nilesh_gangurde — Tue, 04 Feb 2014 11:40:36 GMT

Thanks Fabrice.

-Nilesh