Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date time and participants for a draw

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

3 Replies
sunny_talwar

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

Not applicable
Author

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

florentina_doga
Partner - Creator III
Partner - Creator III

see attach