topic Re: previous 6 month expression not working in App Development

previous 6 month expression not working

anwarbham — Sat, 16 Nov 2024 01:48:34 GMT

Hi guys im confused why a simple expression to get the last 6 month data wont bring me any results

i have a master calender the one below

Qlik sense represents the date Field as '18/02/2020'

I have a simple expression to get the last 6 month data but it wont yield any results.

but I do get the last 6 month data if i use this

Count({$<_DataSource_F_Call$(vLiz_Set_SnapshotSwitch)={1},_ChannelCriteria={1},_IndividualCustomer={1},Timeframe={MTH},$(vLiz_Set_Territory),Product=, Month= { "$(=Month(addmonths(Today(),-6)))", "$(=Month(addmonths(Today(),-5)))", "$(=Month(addmonths(Today(),-4)))", "$(=Month(addmonths(Today(),-3)))", "$(=Month(addmonths(Today(),-2)))", "$(=Month(addmonths(Today(),-1)))", "$(=Month(Today()))" }, Year = {"$(=Year(Today()))"}>} DISTINCT Contact_Cnt)

can anyone tell me why or help

Thanks

Re: previous 6 month expression not working

Kushal_Chawda — Fri, 24 Jul 2020 13:32:48 GMT

try with double quotes

Re: previous 6 month expression not working

anwarbham — Fri, 24 Jul 2020 14:01:39 GMT

it works if I remove the equal sign

Date = {">=$(addmonths(today(),-6))"}

instead of

Date = {">=$(=addmonths(today(),-6))"}

only problem is if I don't have the current year in selection it includes data from previous year

Re: previous 6 month expression not working

Kushal_Chawda — Fri, 24 Jul 2020 14:06:47 GMT

What do you want to achieve?

Re: previous 6 month expression not working

anwarbham — Mon, 27 Jul 2020 08:12:28 GMT

I just need to count the last 6 month from today and the last 24 month from today, without selecting the year

Re: previous 6 month expression not working

anwarbham — Mon, 27 Jul 2020 14:28:38 GMT

Fixed with the below codeas en example for 12 month

Count({$<_DataSource_F_Call$(vLiz_Set_SnapshotSwitch)={1},_ChannelCriteria={1},_IndividualCustomer={1},Timeframe={MTH},$(vLiz_Set_Territory),
Date = {">=$(=date(addmonths(today(),-12),'DD/MM/YYYY'))"} >} DISTINCT Contact_Cnt)