topic Count values in a calculated field in QlikView

Count values in a calculated field

Orsi68 — Wed, 09 Nov 2022 12:32:49 GMT

Hi to all,I have a problem: I have a table with five fields (Serial number, Surname, Name, Date of discharge) and the last one is a calculated field. In the calculated field I identify all the people who resigned in the selected period and those who will resign outside the same period. These are labeled with the words "Ceased" and "Future_Ceased". In another table I want to count the total number of Ceased and Future_Ceased. How can I do? Thank you all

Re: Count values in a calculated field

PrashantSangle — Wed, 09 Nov 2022 12:45:30 GMT

can you share you script?

also share where you want the solution in back end (script) or in front end?

Regards,

Prashant Sangle

Re: Count values in a calculated field

Orsi68 — Wed, 09 Nov 2022 13:09:00 GMT

Hi,

I used the following:

=if(Data_Dimissione_Cessandi_Cessati<=($(=max(Anno_Competenza))&'-'&(If(GetSelectedCount(Mese_Competenza), Max(Mese_Competenza))+1)&'-01'),'Cessato','Cessando')

when 'Cessando' is the resigned and "Cessando" is the others.

It is fine both as a script and as a front-end just solve and be able to count them in real time. If you succeed both ways it would be great.
Thank you very much

Re: Count values in a calculated field

Janii786 — Mon, 26 Dec 2022 09:50:00 GMT

can you share you script?

also share where you want the solution in back end (script) or in front end?

Regards,

Prashant Sangle

topic Count values ​​in a calculated field in QlikView

Count values ​​in a calculated field

Re: Count values ​​in a calculated field

Re: Count values ​​in a calculated field

Re: Count values ​​in a calculated field

topic Count values in a calculated field in QlikView

Count values in a calculated field

Re: Count values in a calculated field

Re: Count values in a calculated field

Re: Count values in a calculated field