Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display user for all possible dates

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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.

View solution in original post

5 Replies
Anil_Babu_Samineni

Use DISTINCT after Load statement like

Load DISTINCT F1, F2, .....

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

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
Not applicable
Author

Got null values in date column

tresesco
MVP
MVP

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
Not applicable
Author

Thanks. it worked