repetition on yearmonth values in the filter

SoillBIQlikSense — Wed, 16 Sep 2020 13:30:03 GMT

Hi I am getting repetition on yearmonth values in the filter. the data comes from 2 joined tables.I expect to get one Yearmonth value but I get multiple values when there is more than one invoice in the same month. See below.

Re: repetition on yearmonth values in the filter

hendrik_faurie — Thu, 17 Sep 2020 14:56:39 GMT

Hi there,

Not sure I follow... Do you mean the repetition of the InvoiceYearMonth in the tables? Or if you were to add a plain filter box object of the InvoiceYearMonth field, do you see values duplicated in that?

In case of the latter then it means that your dates are in fact different values. Qlik Date fields can hold down to timestamp detail. Even if you see in a filter 2x the same value "2020-12-31", if you were to check with the timestamp function you'd probably see that the one is "2020-12-31 00:00:00", and the other "2020-12-31 23:59:99".

In script you can say:

Date(FLOOR(InvoiceYearMonth),'YYYYMM') AS InvoiceYearMonth

This should force all timestamps to 00:00:00 and remove "duplicated" values.

Shout if this didn't solve your issue and maybe then also just provide a bit more detail and will see if we can help.

topic Re: repetition on yearmonth values in the filter in App Development

repetition on yearmonth values in the filter

Re: repetition on yearmonth values in the filter