topic Display user for all possible dates in QlikView

Display user for all possible dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data as in table1 and want to display user across each date(as table 2).

eg.: 'a' is present at two different time stamps on 10/10/2017. But I need to display only once across 10/10/2017

Please let me know how this can be possible at script end and in chart expressions.

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:56:09 GMT

Use DISTINCT after Load statement like

Load DISTINCT F1, F2, .....

tresB — Thu, 12 Oct 2017 11:59:15 GMT

Create a Date field in the script using floor() like:

Load

user,

Date(Floor(date)) as NewDate

Now if you take this user and NewDate in the table box, it should give your expected output.

Anonymous — Thu, 12 Oct 2017 12:16:28 GMT

Got null values in date column

tresB — Thu, 12 Oct 2017 12:19:44 GMT

That could be if your date field is not really a date but string. Try using parsing function date#(), like :

Load

user,

Date(Floor(date#(date,'DD/MM/YYYY hh:mm:ss'))) as NewDate

Note: Check the date format and change if required.

Anonymous — Thu, 12 Oct 2017 12:22:51 GMT

Thanks. it worked