topic Re: date time and participants for a draw in QlikView

date time and participants for a draw

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

This is my script, i am gathering information on participants for a draw and i would like to do 2 things.

1. Number of participants : To have a graph to be able to track number of participants day by day and also hour by hour. what would be the best graph to use ? and expressions ?

2. Estimation of participants : based on current progress, i would like to be able to estimate potential number of participants for each language (CH, FR, ZH, EN, ES).

THanks for your help

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Pays,
Date(Floor([Date de création])) as Date,

Time(Frac([Date de création])) as Time

Ce message a été modifié par : Jean-Philippe Favre

Re: date time and participants for a draw

sunny_talwar — Mon, 09 May 2016 12:19:28 GMT

Would you be able to share a sample application where there is some data to play around with?

Re: date time and participants for a draw

Mon, 09 May 2016 13:01:48 GMT

Done with real data modified for privacy reason, but you have exactly the kind of data that i am getting

Re: date time and participants for a draw

florentina_doga — Mon, 09 May 2016 13:35:47 GMT

see attach