topic Re: Difficult Logic in QlikView

Difficult Logic

smilingjohn — Sat, 16 Nov 2024 17:50:53 GMT

Hi Expertise ,

For me this is becoming really very difficult . Please find the attachment of the QVW and Excel sheet . I have two dates

one is "TakenDate" and the other one is "Updated" . Now i want to have a one field of year and month and upon selecting the year and month it should give me the data related to that year and month .

For example i select May month then it should show me all the records in the month of may . ( SOme are from TakenDate and some are from Updated) .

Re: Difficult Logic

martinpohl — Tue, 10 Nov 2020 11:41:40 GMT

So you have to load your data two times

load

ID,

severity,

'taken' as time_type,

takendate as date

from your data;

load

ID,

severity,

'updated' as time_type,

updatedate as date

from your data;

then create a master calender from field date.

The field time_type is to identify how many creations and updates are in the period.

Regards

Re: Difficult Logic

smilingjohn — Tue, 10 Nov 2020 11:50:48 GMT

Thanks @ martinpohl

If you can please use the excel sheet and give me the example it would really be helpfull .

Thanks

Re: Difficult Logic

smilingjohn — Wed, 11 Nov 2020 08:01:02 GMT

@martinpohl I have implemented your logic but it shows double records . Can you please look into the attachment .

Thanks

Re: Difficult Logic

martinpohl — Tue, 10 Nov 2020 13:09:07 GMT

sure there are double records. but there is the time_type-field, so you only have one type for each record....

Re: Difficult Logic

smilingjohn — Tue, 10 Nov 2020 13:15:59 GMT

But i want to show those dates from time_type field which falls in may .

Is this possible ? Becuase that is what exactly i want when i click on the month it should filter out those dates falling under that month .

Re: Difficult Logic

smilingjohn — Tue, 10 Nov 2020 16:32:34 GMT

Hi Community,

Any help on this ?

Re: Difficult Logic

Kushal_Chawda — Tue, 10 Nov 2020 17:05:51 GMT

@smilingjohn refer below

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578