topic Re: Comparison - Analysis in QlikView

Comparison - Analysis

amatvejeva001 — Mon, 25 Feb 2019 15:05:13 GMT

Hi guys,

I am new toQ likview so it might be a silly question, but I would really appreciate any help.

I have uploaded 2 tables with exactly the same layout to qlikview (just different dates of computation and Property ID's and I will be uploading more Excel sheets on a weekly basis.

My Data looks like this

Date Computed	Rationale	Property ID
20190215	Clean	XX11
20190215	Descoped	XX2
20190215	Okay	XX3
20190215	Okay For EDD	XX4
20190215	Judgements	XX5
20190215	Sale	XX6
20190215	Issue	XX7
20190215	Clean	XX2
20190215	Descoped	XX3
20190215	Issue	XX1
20190221	Clean	XX1
20190221	Descoped	XX2
20190221	Okay	XX3
20190221	Okay For EDD	XX4
20190221	Judgements	XX5
20190221	Sale	XX6
20190221	Issue	XX7

I would like to create:

1) Calendar where I could select 2 Dates to compare i.e. 15/02/2019 VS 21/02/2019

2) And a table like below to compare the number of properties that had certain Rationales on Date X with Date Y

So if i select on the calendar: compare 15/02/2019 with 21/02/209 a table should look like this

Rationale	Number of properties on 15/02/2019	Number of properties on 21/02/2019	Change
Clean	2	1	-50%
Descoped	2	1	-50%
Okay	1	1	0%
Okay For EDD	1	1	0%
Judgements	1	1	0%
Sale	1	1	0%
Issue	2	1	-50%

Thanks you very much in advance!!

Re: Comparison - Analysis

prieper — Tue, 26 Feb 2019 08:57:37 GMT

Think that easiest would be to use "Alternate States" on the Dates.

Please check the OL-Help for

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Alternate%20States.htm

Peter

Re: Comparison - Analysis

Shubham_Deshmukh — Tue, 26 Feb 2019 09:53:06 GMT

1. Create 2 variables vStartDate and vEndDate in setting->Variable overview , give value as your date fields and then create 2 calendar objects and select variable like below, now you are able to select start date and end date,

2. Use below expressions ,

Re: Comparison - Analysis

amatvejeva001 — Tue, 26 Feb 2019 11:26:56 GMT

Hi Shubham,

Thanks for the reply

So when i set the variables

This is what caendar looks like and the table isnt populating

Why could this be the case?

Re: Comparison - Analysis

Shubham_Deshmukh — Tue, 26 Feb 2019 11:36:18 GMT

Firstly, give limits in Min Max values like, Min value = min(dateField) , Max Value = (max(dateField)
You need to create 2 different calendar objects, you have created one and given both values.
one for start date and one for end Date.
And have you given values to variable in Variable overview ?

Re: Comparison - Analysis

Shubham_Deshmukh — Tue, 05 Mar 2019 06:37:56 GMT

Hey @amatvejeva001

Mark the solution if it solves your issue so that other can get an idea.