Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

christiane2003
New Contributor II

Compare two cases in Qlik Sense

Hi all,

I tried to compare two cases that are in seperate tables (pls. see attached qvw-file). I could implement that in Qlikview. However this is not possible to rebuild that in sense. Thanks for any clues.

Best regards

1 Solution

Accepted Solutions
felipedl
Valued Contributor III

Re: Compare two cases in Qlik Sense

Hi Christiane,


What exactly isnt working?


Just copied and pasted everything into Sense:

sample.png

Same as the one from View as to my understanding.

5 Replies
felipedl
Valued Contributor III

Re: Compare two cases in Qlik Sense

Hi Christiane,


What exactly isnt working?


Just copied and pasted everything into Sense:

sample.png

Same as the one from View as to my understanding.

devarasu07
Honored Contributor II

Re: Compare two cases in Qlik Sense

Hi,

I don't see any issue here. can you elaborate more. your qlikview document chart object can be done and able to get the desired output using qliksense. Thanks Deva

christiane2003
New Contributor II

Re: Compare two cases in Qlik Sense

Thank you Felip for response. Meanwhile I was able to rebuild in Qlik Sense. What isnt working exactly in this set-up is that Sense is very sluggish regarding mass data. Do you now why?

Thank you!

felipedl
Valued Contributor III

Re: Compare two cases in Qlik Sense

If you load the exact same data in View, do you get a "quicker" response so to say?

As to my understanding, both use the same engine for later releases regarding the ETL process and the difference would be in the UI part.

I've loaded quite large bases into Sense (some million rows and so) and couldn't see extreme time differences between both in the ETL process.

christiane2003
New Contributor II

Re: Compare two cases in Qlik Sense

Thank you for feedback. I see the problem, that I cannot use this solution for any complex cases. For example I currently try to compare a table with a copy of this table. The comparision must be between only one similar dimension. Means shape1 (source dimension) shall be set opposite another shape (e.g. shape2 in copied table). I use a calculated dimension like in attached qvw before. However it isnt possible  to run that comparison because qlik runs in continuous loop modus. Any idea?