topic Re: Reference data not getting loaded untill I reload in QlikView

Reference data not getting loaded untill I reload

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

Hello all,

I am working on the straight table where in I am showing Country and sales. Requirement is to show 20 countries every time.

e.g. Even if I receive sales data for 5 countries, I need to show '0' sales for rest 15 countries.

For that I am loading Country’s reference data table having 20 countries along with actual data sheet. So that in table there always will be 20 countries.

Now the issue is - when I am opening my dashboard it is showing only those countries present in actual data. Post reload it is showing all the 20 Countries. Not getting why reference data is not getting loaded at first instance only.

Hope I am clear with my requirements.

Re: Reference data not getting loaded untill I reload

ahaahaaha — Mon, 28 Aug 2017 06:52:28 GMT

Hi,

Try to remove the flag

Re: Reference data not getting loaded untill I reload

arvind_patil — Mon, 28 Aug 2017 07:13:07 GMT

Hi Onkar,

could you provide sample app.

Thanks,

Arvind patil

Re: Reference data not getting loaded untill I reload

onkarkulkarni — Mon, 28 Aug 2017 08:02:47 GMT

This is already removed.

Re: Reference data not getting loaded untill I reload

stabben23 — Mon, 28 Aug 2017 08:44:19 GMT

Hi Onkar,

try to tick "Show all Values" in dimensiontab, then untick "Suppress Zero-Values" in presentation tab.

Re: Reference data not getting loaded untill I reload

onkarkulkarni — Mon, 28 Aug 2017 10:29:00 GMT

Tried that as well. Actually I noticed that section access code is impacting entire application. If I comment that it is working fine

Re: Reference data not getting loaded untill I reload

stabben23 — Mon, 28 Aug 2017 10:47:13 GMT

Ok, so sequrity comes in second hand?! Better GUI is Perfect? You gambling to high I think.