Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
amatvejeva001
New Contributor

Comparison - Analysis

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 ComputedRationaleProperty ID
20190215CleanXX11
20190215DescopedXX2
20190215Okay XX3
20190215Okay For EDD XX4
20190215JudgementsXX5
20190215SaleXX6
20190215IssueXX7
20190215CleanXX2
20190215DescopedXX3
20190215IssueXX1
20190221CleanXX1
20190221DescopedXX2
20190221Okay XX3
20190221Okay For EDD XX4
20190221JudgementsXX5
20190221SaleXX6
20190221Issue

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 

RationaleNumber of properties on 15/02/2019Number of properties on 21/02/2019Change
Clean21-50%
Descoped21-50%
Okay 110%
Okay For EDD 110%
Judgements110%
Sale110%
Issue21-50%

 

Thanks you very much in advance!!

5 Replies
prieper
Honored Contributor II

Re: Comparison - Analysis

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

Shubham_Deshmukh
Valued Contributor

Re: Comparison - Analysis

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,

Untitled.png

QWQW.png

2. Use below expressions ,q.png

amatvejeva001
New Contributor

Re: Comparison - Analysis

Hi Shubham,

Thanks for the reply

So when i set the variables

1.png

 

2.png

This is what caendar looks like and the table isnt populating

3.png

Why could this be the case?

Shubham_Deshmukh
Valued Contributor

Re: Comparison - Analysis

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 ?

rt.png

Highlighted
Shubham_Deshmukh
Valued Contributor

Re: Comparison - Analysis

Hey @amatvejeva001 

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