Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
gsaipranathi
Contributor III
Contributor III

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, .....

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.

gsaipranathi
Contributor III
Contributor III
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.

gsaipranathi
Contributor III
Contributor III
Author

Thanks. it worked