topic Re: Alternates states to compare highest 5 values in current month to the same values in previous month in QlikView

Alternates states to compare highest 5 values in current month to the same values in previous month

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

can we define alternate states dynamically

i have a requiremnt,where i have to compare,the selected month top 5 values,to the same values in previous month.

i can give two list boxes to the end user but he dont want in that way

when he selects a particular month he need to com[pare the top 5 values in the current month to the same values in previous month as below

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Anil_Babu_Samineni — Sun, 16 Oct 2016 17:38:05 GMT

Here, You've hit the 2016 Jun. From This what are you expecting the Labels for Dim

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Sun, 16 Oct 2016 19:44:16 GMT

Hi all Please help me out top two values in current month comparing the same with previous month.

In June the top two profitted cuntries are Argentina and Japan

In May the top two profitted cuntries are America and Argentina

What i want is when i click on jun i want both june and may data to dispaly and the comparision should be between the selected month (jun) and top two values of it Argentina and Japan to Argentina and Japanin May

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Mon, 17 Oct 2016 10:14:26 GMT

it will be helpful if you give me a sample

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

beck_bakytbek — Mon, 17 Oct 2016 10:35:17 GMT

Hi John

Did you solve your issue ? let me know, otherwise i build for en example?

beck

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Mon, 17 Oct 2016 10:48:03 GMT

Month products city

Jan 2016 10 tokyo

Jan 2016 25 newyork

Jan 2016 45 brazil

Feb 2016 30 hongkong

Feb 2016 15 tokyo

Feb 2016 20 newyork

My requirement is i have a bar chart

I'm calculating sum of products in a particular month

I have applied dimension limits to it show largest 2 values

In january it shows brazil and newyork

In february it shows newyork and hongkong

What i want is i want to compare the top 2 values which are in january to feb ie in feb i want to see brazil and newyork but not newyork and hongkong

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Mon, 17 Oct 2016 10:49:01 GMT

Hi beck it would be of great help from your side

Month products city

Jan 2016 10 tokyo

Jan 2016 25 newyork

Jan 2016 45 brazil

Feb 2016 30 hongkong

Feb 2016 15 tokyo

Feb 2016 20 newyork

My requirement is i have a bar chart

I'm calculating sum of products in a particular month

I have applied dimension limits to it show largest 2 values

In january it shows brazil and newyork

In february it shows newyork and hongkong

What i want is i want to compare the top 2 values which are in january to feb ie in feb i want to see brazil and newyork but not newyork and hongkong

I was bit struggling with these

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

beck_bakytbek — Mon, 17 Oct 2016 11:16:07 GMT

Hi John,

i created an example, take a look and please give me your Feedback,

i hope that helps to resolve your issue

beck

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

tresB — Mon, 17 Oct 2016 12:31:28 GMT

You have to use p() in set expression like:

Exp1: Sum({<city=p({1<Month={"$(=date(Addmonths(Max(Month),-1),'MMM YYYY'))"}>}city)>}products)

Exp2: Sum({<Month={"$(=date(Addmonths(Max(Month),-1),'MMM YYYY'))"}>}products)

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

beck_bakytbek — Mon, 17 Oct 2016 14:09:04 GMT

Hi John?

Have you solved your issue?

beck

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Mon, 17 Oct 2016 17:27:02 GMT

Hi Tresseco, user can click on any month

If there is no month before the current selected month it should show only largest values in current month

when I’m selecting jan 2016 the top two values are not appearing

and if I have only one value in the current month then in the previous month only one value should be shown ie the current month has only one value the previous month should show this value

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Mon, 17 Oct 2016 17:30:58 GMT

Hi Beck I'm unable to open the document, as i'm using personal edition, can you please share the code.

please

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

beck_bakytbek — Mon, 17 Oct 2016 18:21:05 GMT

Hi John,

i am now out the office, tomorrow i will send to you the complete code.

beck

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Tue, 18 Oct 2016 02:26:49 GMT

try this:

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

Tue, 18 Oct 2016 02:37:56 GMT

This is a nice solution,and if add p() in your expression to filter the "Month", it will be nicer.

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

varshavig12 — Tue, 18 Oct 2016 03:38:26 GMT

Top two values in current month comparing the same values with previous month

Re: Alternates states to compare highest 5 values in current month to the same values in previous month

beck_bakytbek — Tue, 18 Oct 2016 08:08:32 GMT

Hi John,

as promised, i want to describe my way of proceeding how i created my example:

First Chart:

Step 1 : Dimension : 1.Month

2. Top 2: if(aggr(rank(sum(Products)),City) < =2, City, Null()) dont forget (Suppress When Value is Null)

Step 2: Expressions: Sum(Product)

Second Chart:

Step 1 : Dimension : 1.Month

2. Top 2: if(aggr(rank(sum(Products)),City) < =2, City, Null()) dont forget (Suppress When Value is Null)

Step 2: Expressions: Jan 16 : Sum({<Month = {'Jan 16'}>}Products)

Feb 16: Sum({<Month = {'Feb 16'}>}Products)

in addition i created one listbox with the Field: Month

try to implement it and give me your feedback

i hope that resolves your issue

beck