Hi,
im hoping the community can help me with something simple.
I am getting duplicate values within my Qlikview app when im reading in from a text file. is there a way to just show unique values depending on date and time? ive tried the floor and distinct function with no luck. my duplicates dates, reading in from a text file look like this: 04/23/2020 02:00:00 . they would then have a number dates/times repeating.
the duplicate values are within the text file i am reading from that have the column "Date" i am reading in. is there anyway to have an expression in within my straight table or in the load code to ignore duplicate dates? thanks
