topic Re: How to create dynamic comparison table with trend , based on prior period rank ? in QlikView

How to create dynamic comparison table with trend , based on prior period rank ?

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

Hi All ,

How to create dynamic comparison table with trend , based on prior period rank ?

Data Input

Year-Qtr	Stakeholder	Location	Strike_Intensity_Rank
2016-Q1	Chromite Inc.	Frankfurt	6
2016-Q2	Falcon Sphere	Lisbon	4
2016-Q3	Drome Lui and CO.	Seol	8
2016-Q4	A&A Confectionary	Sychelles	8
2016-Q1	Chromite Inc.	-	5
2016-Q2	Falcon Sphere	-	6
2016-Q3	Drome Lui and CO.	-	8
2016-Q4	A&A Confectionary	-	3
2017-Q1	Chromite Inc.	Frankfurt	2
2017-Q2	Falcon Sphere	Lisbon	7
2017-Q3	Drome Lui and CO.	Seol	3
2017-Q4	A&A Confectionary	Sychelles	8
2017-Q1	Chromite Inc.	-	8
2017-Q2	Warton Engineering	-	8
2017-Q3	Drome Lui and CO.	-	4
2017-Q4	A&A Confectionary	-	9
2018-Q1	Chromite Inc.	Frankfurt	9
2018-Q2	Falcon Sphere	Lisbon	6
2018-Q3	Drome Lui and CO.	Seol	4
2018-Q4	A&A Confectionary	Sychelles	1
2018-Q1	Chromite Inc.	-	6
2018-Q2	Falcon Sphere	-	7

OUPUT : When Default Period Range = 1

Default period Range

Thanks & Regards

Shekar

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 11:31:38 GMT

Hi Sunny Bhai , stalwar1‌

Please help .

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 11:38:11 GMT

Why is default view for 2017 and not 2018?

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 11:43:06 GMT

2018 is the current year and in real time for 2018 we dont have data for its q3 and q4 . But for sake of testing i addded Q3 - O4 data in 2018 .

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 11:46:23 GMT

So, default will be always one year before the current year?

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 11:47:26 GMT

Yes

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 12:08:28 GMT

Check the attached

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:13:12 GMT

Thank You Sunny Bhai .... But default period range functionality is not there .

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 12:14:10 GMT

What are you seeing, not this?

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:15:56 GMT

Also ,

Location -= {'-'} . Actually "-" was referred for highlighting null values

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 12:17:33 GMT

Then use this

Location = {"*"}

Don't take me in a wrong way, but are you not comfortable in using simple set analysis like this? I strongly suggest mastering set analysis as that is one of the easier things you can quickly learn.

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:18:09 GMT

default period range functionality

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 12:20:13 GMT

What exactly is that?

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:21:15 GMT

Not at all . Any advice from you is highly welcomed .

That was not a problem though . Extremely Sorry for trivial stuff .

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:28:58 GMT

Ok .

These are some set of values in Input box .

When value is 1 , then we get result exactly like what you have shared . Which means take period from dimension values and compare its rank with a year back data (rank) .

So when this value is 2 then , it should toggle 2 year back .

for example : for 2018-Q1 , it should compare rank of 2016-Q1 .

So when this value is 3 then , it should toggle 3 year back .

for example : for 2018-Q1 , it should compare rank of 2015-Q1 .

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Tue, 26 Jun 2018 12:33:12 GMT

check now...

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Tue, 26 Jun 2018 12:45:13 GMT

Namo .. Please Take a bow from myself

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Wed, 27 Jun 2018 13:13:50 GMT

Hi Sunny Bhai , stalwar1‌

I tried alternate way using replace function and variable , but in vain .

Can you please help me know that what is wrong with it ?

Thanks & Regards

Shekar

Re: How to create dynamic comparison table with trend , based on prior period rank ?

sunny_talwar — Wed, 27 Jun 2018 13:18:36 GMT

You want this to work in set analysis? But set analysis only get evaluated once per chart.... you cannot have dimension wise expansion of set analysis... unfortunately, this won't work...

Re: How to create dynamic comparison table with trend , based on prior period rank ?

shekhar_analyti — Wed, 27 Jun 2018 13:22:54 GMT

Ok . Any other alternate way to your existing solution . Probably at script level .