topic Re: Issue in New Qlikview versions in QlikView

Issue in New Qlikview versions

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

I have a pivot table and when i open it in 11.00 it looks ok and display all the records. but when i open it in 11.20 version it remove several raw. why these two versions behave differently.

Thanks

Re: Issue in New Qlikview versions

robert_mika — Tue, 28 Jun 2016 08:52:13 GMT

Could you post a screenshot?

By "raw" do you mean "row"?

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 08:55:29 GMT

yes, sorry for the typing errors.

qvw attached

Re: Issue in New Qlikview versions

Chanty4u — Tue, 28 Jun 2016 08:59:23 GMT

no qvw?

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:00:14 GMT

See attached

Re: Issue in New Qlikview versions

Chanty4u — Tue, 28 Jun 2016 09:04:57 GMT

yes but... am usng 11.2

it shwng below details witout any selections?

what ur getting plz share the screen?

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:21:52 GMT

see attached for qv 11.00 data and qv 11.20 data output

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:22:40 GMT

see below comparisons in two versions

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:33:26 GMT

i have attached the output of two versions

Re: Issue in New Qlikview versions

Chanty4u — Tue, 28 Jun 2016 09:38:15 GMT

am not sure..

chk dis

Qlikview subversion data reload issue. | Qlik Community

https://community.qlik.com/message/503690?&_ga=1.60174511.361223566.1464856326#503690

Re: Issue in New Qlikview versions

Anonymous — Tue, 28 Jun 2016 09:43:32 GMT

Hi Anuradha,

It seems that you are hidding null values.

Confirm if that is not checked.

Regards!

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:45:35 GMT

yes, i have done it purposely, but the problem i have is why the same qvw behave differently in 11.00 and 11.20

Re: Issue in New Qlikview versions

Anonymous — Tue, 28 Jun 2016 09:51:54 GMT

Hi Anuradha,

The only rows that have "issues", are the rows that you are hidding with null values, where do you see more issues?

Regards.

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 09:57:29 GMT

No, I have open same file in two versions and i have attcehd the screenshots of the output.

In 11.00 it has more values and 11.20 it remove lot of rows.

Re: Issue in New Qlikview versions

Anonymous — Tue, 28 Jun 2016 10:10:38 GMT

How many rows do you have on version 11.0?

Re: Issue in New Qlikview versions

anuradhaa — Tue, 28 Jun 2016 10:27:23 GMT

see attached for version 11.00 and 11.20

Re: Issue in New Qlikview versions

kimosterby — Tue, 28 Jun 2016 10:48:52 GMT

I can only see that 11.00 is not doing what it is supposed to do as it shows all values in the Tag column despite that it should suppress Null values. As Manuel Capella wrote:

Hi Anuradha,

It seems that you are hidding null values.

Confirm if that is not checked.

Just remove the check mark and they will be alike. I don't know whether it is a bug in 11.00, but as it works as supposed to in 11.20 there is no problem anymore.

Re: Issue in New Qlikview versions

Anonymous — Tue, 28 Jun 2016 11:08:58 GMT

There I can't see total number of rows, but when i uncheck hide null values on dims, i can see 3716 rows on your chart. If i check this option, I only see 24.

Regards!

Re: Issue in New Qlikview versions

Anonymous — Tue, 28 Jun 2016 11:18:53 GMT

I am not sure what is going on in your application. When i select Chandika Gunawardhana as the Reported By there are no values in your Entry record. Therefore the row is not being shown. To ensure null's are not suppressed uncheck the folllowing options on the Presentation tab. Your image of 11.00 is showing values. Something else has changed.