topic Re: Before selecting: wrong data; After selecting: correct data in App Development

Before selecting: wrong data; After selecting: correct data

adlisval — Fri, 14 Sep 2018 08:54:57 GMT

I will post 3 images, each having a table and a line chart.

The used data is exactly the same (it's using the same measure and the same dimensions).

PROBLEM:

1a. the data shown, before any selection, is wrong both in the table and in the line chart (see 1st image).

1b. After a selection is made (click on a point in the line chart - *without confirming* the selection), the data is correct in the table (see 2nd image).

1c. After a selection is made (click on a point in the line chart - *with confirming* the selection), the data is correct both in the table and in the line chart (see 3rd image).

QUESTION: why is the data displayed before any selection is wrong and after selection is correct? How to fix it?

1st image

2nd image

3rd image

Re: Before selecting: wrong data; After selecting: correct data

ali_hijazi — Fri, 14 Sep 2018 08:57:46 GMT

what is the expression that you are using?

Re: Before selecting: wrong data; After selecting: correct data

YoussefBelloum — Fri, 14 Sep 2018 08:59:13 GMT

Hi,

would you be able to attach sample QVF file ?

Re: Before selecting: wrong data; After selecting: correct data

adlisval — Fri, 14 Sep 2018 09:08:25 GMT

Hey, thanks for the replay. The date is the measure and the dimension is:

LET mNewCustomerCount

= 'SUM(' & Chr(36) & '(setActuals) IF([datum] >= ' & Chr(36) & '(vDateStart) AND [datum] <= ' & Chr(36) & '(vDateEnd), c_distinct_count))';

Re: Before selecting: wrong data; After selecting: correct data

adlisval — Fri, 14 Sep 2018 09:10:04 GMT

wish I could, but no. thanks anyway

Re: Before selecting: wrong data; After selecting: correct data

ali_hijazi — Fri, 14 Sep 2018 09:17:46 GMT

why you are complicating things!

remove the if else condition and put it in the set analysis:

sum({<datum={">=$(vDateStart) <=$(vDateEnd)"}>}c_distinct_count)

what is in setActuals?

Re: Before selecting: wrong data; After selecting: correct data

adlisval — Fri, 14 Sep 2018 09:22:33 GMT

setActuals = it's a flag for this year or last year.

But the behavior is strange, don't think the formula is wrong. Why does it show correct results when I specifically select a date, and wrong results when the dates are NOT selected....?

Re: Before selecting: wrong data; After selecting: correct data

ali_hijazi — Fri, 14 Sep 2018 14:36:15 GMT

I never use if else in expression

always try to put all login in set analysis format

Re: Before selecting: wrong data; After selecting: correct data

adlisval — Mon, 17 Sep 2018 11:43:10 GMT

The problem are the 2 variables vDateStart and vDateEnd. They are the MIN and MAX of Datum (not the "datum" used in the formula posted above). But the issue is that, for some reason, the variables do not get correctly calculated when they are used in the formula mentioned above:

LET mNewCustomerCount

= 'SUM(' & Chr(36) & '(setActuals) IF([datum] >= ' & Chr(36) & '(vDateStart) AND [datum] <= ' & Chr(36) & '(vDateEnd), c_distinct_count))';

Not sure how to fix the problem, but that is the problem. I used hardcoded dates in the formula, instead of using the variables vDateStart and vDateEnd, and the results were correct. It might be a Qlik Sense bug, not sure.