topic Re: Alternate State Not Showing All Data in QlikView

Alternate State Not Showing All Data

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

I created a pivot a month or two ago that shows counts per month per system. Today I added data from an additional system but the data will not show in the pivot unless I take the alternate state(BillingSummary) out of the expression. I'm drawing a blank on why this would happen. Any ideas?

Num(Count({BillingSummary<InFRoll13Flag = {1}>*$}DISTINCT InFPolicyNumber), '#,##0')

Re: Alternate State Not Showing All Data

lorenzoconforti — Wed, 07 Feb 2018 14:24:29 GMT

Maybe that alternate state is filtered and can't see it? what if you add Current selections box object pointing to that alternate state

Does it show any filter being applied?

Re: Alternate State Not Showing All Data

greend21 — Wed, 07 Feb 2018 21:08:03 GMT

I just tried that after you suggested it just in case but there isn't anything i'm not already away of. I'm using the alternate state for a few selections because I want one of the options always defaulted to selected, but I do not want it to affect data on other sheets. If I take the alternate state out of the set analysis then the selection does not filter this pivot as it should but then I can see the new system's data. The new system I added is unioned to the others so the data is in the same format. I'm really not sure what could be causing this issue.

Re: Alternate State Not Showing All Data

lorenzoconforti — Wed, 07 Feb 2018 21:22:25 GMT

Two things might be happening here:

1. "I want one of the options always defaulted to selected": your default selection is somehow filtering out the new system data

2. "The new system I added is unioned to the others so the data is in the same format": the new system data might have similar format but reside in a different table (i.e. the data structure is inconsistent)

Options:

- share the data model so that we can help you quickly

- if you can't share the data model, share a screenshot of the database structure (CTRL+T)

- share more info about the tables and expressions

Re: Alternate State Not Showing All Data

greend21 — Thu, 08 Feb 2018 15:10:35 GMT

Oddly enough, I reloaded the data this morning and now my data shows with even with the alternate state in the set analysis.