topic Re: Pivot Table filter issue in App Development

Pivot Table filter issue

tauceef9 — Mon, 17 Sep 2018 09:44:11 GMT

Hi All,

We have a pivot table with monthly trend starting from May-18.

Issue is when we select all the values from the filter and then deselect any month it is showing next month as deselected "white background" but in actual it is not deselected. I am attaching screenshot of the same. I have deselected May-18 from the list and it is showing "Jun-18" in white background which looks like June month is also deselected and when we try to select Jun-18 it deselects that month as well.

This is very confusing to the end users.

Has anyone else faced this issue or have any solution to it?

QlikSenseDesktop June 18 version

Regards,

Tauceef

Re: Pivot Table filter issue

YoussefBelloum — Mon, 17 Sep 2018 09:48:00 GMT

Hi,

when you select all values and then you deselect Jun-18, what happens ?

Re: Pivot Table filter issue

tauceef9 — Mon, 17 Sep 2018 13:39:04 GMT

Hi Youssef,

It's showing Jul-18 (next month) in white background.

i.e. if we select any month it's next month is coming in white background except for the last month which is Sep-18 in this case.

Regards,

Tauceef

Re: Pivot Table filter issue

YoussefBelloum — Mon, 17 Sep 2018 14:52:46 GMT

I don't understand..

let's take the example of selecting all the values and deselecting JUN-18, when you deselect JUN-18, only JUN-18 is in white on the listbox, right ? in this case, the next month of JUN-18 is JUL-18..so you mean JUL-18 is also deselected and comes in white ?

Re: Pivot Table filter issue

tauceef9 — Tue, 18 Sep 2018 06:34:55 GMT

Hi Youssef,

You are right when I deselect JUN-18, JUL-18 also comes in white background and appears as if it is deselected as shown in the screenshot above where I deselected MAY-18 and JUN-18 is appearing in white background(but it actually is not deselected). So as a end user I will think that JUL-18 is also deselected and when I try to select JUL-18 then it gets deselected in actual.

I know it is sounding little confusing but I have tried as clear as much as I can .

Regards,

Tauceef

Re: Pivot Table filter issue

YoussefBelloum — Tue, 18 Sep 2018 07:43:39 GMT

Would you be able to share a QVF that shows the issue ?

Re: Pivot Table filter issue

tauceef9 — Tue, 18 Sep 2018 10:44:58 GMT

Hi Youssef,

I would not be able to share the actual application but attached is the app with some sample data. Here also I am having the same issue.

Regards,

Tauceef

Re: Pivot Table filter issue

YoussefBelloum — Tue, 18 Sep 2018 11:20:01 GMT

I've made some tests and it is working as expected for me.. only deselected values appears in white, only the values I deselect are removes from the table and appears in white

Re: Pivot Table filter issue

tauceef9 — Tue, 18 Sep 2018 11:43:02 GMT

Hi Youssef,

Let me share the steps I am doing:

I am selecting all months using selection menu:

so I am getting all months selected:

after that when I deselect May-18, it gets removed from the list and Jun-18 appears in white background (as if it is also deselected):

Hope you are following the same steps.

Further to add, I am having June-18 version in my machine.

Regards,

Tauceef

Re: Pivot Table filter issue

YoussefBelloum — Tue, 18 Sep 2018 12:01:40 GMT

Now I see that... it is weird

but one solution would be to validate your selection (when you select all) before deselecting a value, like this it will work

Hi mto‌ hope you're doing well ? actually I'm curious to know if this issue a bug or something we're missing here ?

the operation is simple:

if we select all values (in month field) and deselect one value (before validating the first step), another value is deselected with the deselected value..

Op described the issue above using screen shots.

Thank you

Re: Pivot Table filter issue

tauceef9 — Wed, 19 Sep 2018 11:31:26 GMT

Hi All,

Can anyone please help me figuring out the issue.

Hi mto‌, would you please share your views also.

Regards,

Tauceef

Re: Pivot Table filter issue

Michael_Tarallo — Wed, 19 Sep 2018 13:46:45 GMT

Hi Guys - I'll have a product manager look at this - czo‌ - is this something you or your team can look at? The Pivot table behavior does the same thing as described - I am not sure why. The .qvf is attached above and the steps are also listed. Let me know your thoughts?

Regards,

Mike T

Qlik

Re: Pivot Table filter issue

YoussefBelloum — Wed, 19 Sep 2018 14:08:37 GMT

Thanks Michael

Re: Pivot Table filter issue

Anders-Fridell — Fri, 21 Sep 2018 09:08:36 GMT

A bug is logged at Qlik R&D and we will look into this. Thank you for your feedback.

Re: Pivot Table filter issue

tauceef9 — Wed, 26 Sep 2018 04:54:35 GMT

Thanks Anders.

Looking forward for your response on this.

Would you please help where can I track the bug reported for this?

Regards,

Tauceef