Dashboard looks fine in Development, but duplicates on server..

[#1]

Hi all,

I have a pivot table which looks fine when refreshed on my PC and viewed from my installation of QlikView.

When I save the refreshed qvw to the server, and view it via a browser, some of the data is duplicated.
This has happened before when I have used 'IF' statements in the dimension fields.

Has anyone else experienced this problem? If so, without doing the calculations.logic in the script, is there a way around this?

Thanks in advance,

Matt

[#2]

Hello Matt

I have found numerous problems using IF statements in dimensions on charts and tables, in short, we avoid them ALL the time, no exceptions.

The workarounds depend on what you're strying to achieve but mainly they require work on the load script to ensure you don't need to use these IF statements. I think the problem is in relation to the ability to make selections from a table by clicking on the dimension itself, I suppose it makes sense that QlikView would get a little confused over what it is really selecting when an IF statement is involved.

Sorry, but my advice is to avoid them.

Cheers,

Nigel.

[#3]

I have had issues exactly like this. When you say you see duplicate data, are you getting the dimension duplicated?

[#4]

I have had issues exactly like this. When you say you see duplicate data, are you getting the dimension duplicated?

[Anonymous]

When using IF in a calculated dimension, it should work properly if you enclose it in AGGR. I can't recall ever having problems with IF.