topic Re: Comparing 2 text fields in Concatenated table in QlikView

Comparing 2 text fields in Concatenated table

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

Hello!

I'd like to create a new column that compares 2 text fields in a concatenated table that varies by week (Previous and Current week), I need to determine if ShipStatus has changes or not from previous and current week. Is this going to be a calculated dimensional field? I tried using the expression but it came out 2 columns for each week.

Pls. see example below :

Thank you in advance.

Re: Comparing 2 text fields in Concatenated table

Anil_Babu_Samineni — Fri, 15 Dec 2017 01:52:54 GMT

So, You want to compare only ShipStatus got changed into new one when week got changed? Does it?

Re: Comparing 2 text fields in Concatenated table

Anonymous — Fri, 15 Dec 2017 16:19:51 GMT

Yes, Anil

Rgds

Re: Comparing 2 text fields in Concatenated table

Anil_Babu_Samineni — Sat, 16 Dec 2017 04:22:01 GMT

Do you have 2 Dates only? Will you attach application to investigate

Re: Comparing 2 text fields in Concatenated table

avinashelite — Sat, 16 Dec 2017 09:38:37 GMT

Share the sample data ...that will help us to get you the solution

Re: Comparing 2 text fields in Concatenated table

Anonymous — Mon, 18 Dec 2017 23:22:08 GMT

Anil,

Every week, it will add new data. However, I will only use the current week and the previous week as comparison. Thus, for this week, I would need the 12/18 and 12/11 records. Anyway, pls. see attached sample file. Hope this helps.

Rgds

Re: Comparing 2 text fields in Concatenated table

Anonymous — Mon, 18 Dec 2017 23:22:59 GMT

Hi! Avinash,

Pls. see attached. Hope this helps.

Tks.

Re: Comparing 2 text fields in Concatenated table

Anil_Babu_Samineni — Tue, 19 Dec 2017 13:22:38 GMT

I've attached for you for speed response. Can you tell me what you are going to achieve from here?

Re: Comparing 2 text fields in Concatenated table

Anonymous — Tue, 19 Dec 2017 16:25:23 GMT

Hi Anil,

I need only the latest week and the previous week (12/11 and 12/18). Thus, need to drop the week 12/04. After this, need to add a new column "Change Status" for comparing the shipstatus between the previous and current week. If both weeks have the same Shipsatus, it will be flagged as "No change", Otherwise, "Change".

Btw I take out the Datekey field from the dimension in your attached so the ShipStatus will be aligned with the 2 weeks.

Tks,