topic Re: Making a Copy of the KPI in QlikView

nothing

ashish1504 — Wed, 20 Apr 2022 10:59:55 GMT

nothing

Re: Making a Copy of the KPI

vchuprina — Mon, 18 Apr 2022 08:55:18 GMT

Hi,

Could you please show your current expression for KPI?

Regards,

Vitalii

Re: Making a Copy of the KPI

anat — Mon, 18 Apr 2022 08:57:10 GMT

copy and paste same kpi and replace 01-01-2018 to 01-01-2022.

for date (01-01-2018),if u r using variables, change the variable logic

Re: Making a Copy of the KPI

anat — Mon, 18 Apr 2022 08:57:28 GMT

or else share the KPI logic.

Re: Making a Copy of the KPI

ashish1504 — Mon, 18 Apr 2022 09:39:25 GMT

sum ({$<Year={'$(vYear)'}, MonthNum={"=$(vMonth)"},Date= , Entity={'PH'}, DISPLAY_FDV={1} >} COLUMN A /1000

Re: Making a Copy of the KPI

anat — Mon, 18 Apr 2022 09:58:05 GMT

as per your logic ,u need to changes vYear variable logic.

Re: Making a Copy of the KPI

anat — Mon, 18 Apr 2022 09:58:51 GMT

share vYear logic,i will guide you what changes need to do

Re: Making a Copy of the KPI

vchuprina — Mon, 18 Apr 2022 10:05:05 GMT

Try to add following to your expression

sum ({$<Year={'$(vYear)'}, MonthNum={"=$(vMonth)"},Date= , Entity={'PH'}, DISPLAY_FDV={1}, Date = {">01-01-2022"} >} COLUMN A /1000

Re: Making a Copy of the KPI

ashish1504 — Mon, 18 Apr 2022 11:23:33 GMT

Hi @vchuprina It does not giving any result.

Re: Making a Copy of the KPI

vchuprina — Mon, 18 Apr 2022 10:57:05 GMT

it's my example:

Date = {">01-01-2022"}

You should put your field here, value format should match with values in your field

[Your field] = {">01-01-2022"}

Regads,

Viltaii

Re: Making a Copy of the KPI

ashish1504 — Mon, 18 Apr 2022 11:25:08 GMT

@vchuprina do I have to do some changes to the Script ?????

Re: Making a Copy of the KPI

vchuprina — Mon, 18 Apr 2022 11:29:30 GMT

No, you shouldn't make any changes, just select the correct field and use the same format of the field.

In my example Date field contains values in the same format MM-DD-YYYY

Date = {">01-01-2022"}

Re: Making a Copy of the KPI

ashish1504 — Mon, 18 Apr 2022 11:58:14 GMT

Hi Anat can you share your contact details so that I can msg you personally