topic Re: Alternate state need to apply for a button in App Development

Alternate state need to apply for a button

Swathi — Tue, 30 Jan 2024 14:47:09 GMT

i have created button to show comparison growth of 2022 vs 2023 values in the button label.i have period filter fot the sheet, and default state period is R12M for that sheet. But in the Button iam showing comparison growth of 2022 vs 2023 values in the button label.. to get for the button period should be Month-Year. i tried to applly alternate state but it is not working. Kindly help me to resolve the issue. for overall sheet default state should R12M, for that buttons it should be month year to get ouput .

Button label expression =if(vasp =1 ,$(vba1),
if(vasp =2 ,NUM($(vba1)/$(Vcount),'#,##0.0%'),
if(vasp =3 ,$(vb1),
NUM($(vb1)/$(Vcount),'#,##0.0%')
)))

Kindly help me to resolve the issue. it's urgent

@Anil_Babu_Samineni ,

@Rohan

@Vegar

Re: Alternate state need to apply for a button

GOKULAKANNAN — Mon, 29 Jan 2024 04:37:44 GMT

Hi Swathi,

Where is the button object you are referring to, and when clicking the button object it should affect only customer behaviour shift object?

Re: Alternate state need to apply for a button

Swathi — Mon, 29 Jan 2024 04:40:53 GMT

@GOKULAKANNAN , Thanks for the reply, can consider all below buttons, i have attached sample sheet

Re: Alternate state need to apply for a button

GOKULAKANNAN — Mon, 29 Jan 2024 04:56:11 GMT

In that case, use Set analysis to directly in the button labels, so that it will show the values accordingly irrespective of selections.

Re: Alternate state need to apply for a button

Swathi — Mon, 29 Jan 2024 05:48:48 GMT

i tried that also but its was interacting with top period filter, i period changing to YTD, R12 M, button alos according to that

Re: Alternate state need to apply for a button

Anil_Babu_Samineni — Tue, 30 Jan 2024 14:42:22 GMT

@Swathi I always recommend to remove logos from your dashboard (To avoid security reasons).

Now, Can we know what you exactly looking for (Looks good if you can share the needs with screenshot)?

Re: Alternate state need to apply for a button

Swathi — Tue, 30 Jan 2024 14:48:16 GMT

i have tktdate, soldtodesc, delvqty field's, i need to calculate common customers falling in current ytd(01-01-2024 to 29-01-2024) and previous ytd (01-01-2023 to 29-01-2023) and volume>0.

How to write expression for these. i tried below but getting error

Count({<Period={'Month-Year'}, tkt_date={"$(PYTD)"},tkt_date={"$(PYTD)"},delv_qty={">0"}>} DISTINCT sold_to_desc)

Re: Alternate state need to apply for a button

GOKULAKANNAN — Tue, 30 Jan 2024 15:04:55 GMT

Hi @Swathi ,

If you want to calculate seperately, then use this

Count({<Period={'Month-Year'}, tkt_date={$(PYTD)},delv_qty={">0"}>} DISTINCT sold_to_desc)

If you want to include both YTD, then create 2 variables and include it.

Re: Alternate state need to apply for a button

Swathi — Tue, 30 Jan 2024 15:42:51 GMT

@GOKULAKANNAN , Thanks for the reply, we have Master Calendar ., created period field, in Period I have YTD and R12M

CYTD and PYTD created in Data Load editor. i am using below, to get common count of customer in cytd and pytd

Count(distinct {1<PYTD={1},CYTD={1},delv_qty={">0"}>} sold_to_desc)

iam getting PYTD count for above not common count of customer.

when i use below formula

Count(distinct {1<CYTD={1},PYTD={1},delv_qty={">0"}>} sold_to_desc )

it is giving CYTD Count, not common count of customers.

I need common count of customers

Re: Alternate state need to apply for a button

GOKULAKANNAN — Tue, 30 Jan 2024 16:11:17 GMT

Hi @Swathi ,

Am not understanding the common count of customers, can you please breif it.

Re: Alternate state need to apply for a button

Swathi — Tue, 30 Jan 2024 16:42:38 GMT

@GOKULAKANNAN , @Anil_Babu_Samineni

we have Master Calendar ., created period field, in Period I have YTD and R12M

CYTD and PYTD created in Data Load editor. i am using below, to get common count of customer in cytd and pytd

Count(distinct {1<PYTD={1},CYTD={1},delv_qty={">0"}>} sold_to_desc)

iam getting PYTD count for above not common count of customer.

when i use below formula

Count(distinct {1<CYTD={1},PYTD={1},delv_qty={">0"}>} sold_to_desc )

it is giving CYTD Count, not common count of customers.

I need common count of customers

Example:

tkt year	customer	delvqty
2023	a	10
2023	b	20
2023	c	0
2023	d	40
2024	a	20
2024	b	30
2024	e	60
2024	f	10
2024	c	30

Coommon customer both 2023 and 204

but has 'c' delv qty zero in 2023, need to exclude that customer

Final Output of common customers

Re: Alternate state need to apply for a button

Anil_Babu_Samineni — Wed, 31 Jan 2024 05:39:08 GMT

@Swathi Great, So with this, You will be having many more years from "tkt year"?