Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Help me to write the following expression

How to write in expression :

if([Fiscal Year] is not selected and [Fiscal Month] is not selected)

[Fiscal Year], [Fiscal Month] are filters.

eg,

=if ([Fiscal Year]=' ' and [Fiscal Month] =' ',

Sum({<[period_key]={$(vMaxPeriod)},[Fiscal Year],[Fiscal Month]=>}inventory_on_hand-qa_blocked_stock),

Sum({<[period_key]={$(vMon)}inventory_on_hand-qa_blocked_stock))

1 Solution

Accepted Solutions
Gysbert_Wassenaar

if(not getselectedcount([Fiscal Year]) and not getselectedcount([Fiscal Month]), ...true..., ...false... )


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
ali_hijazi
Partner - Master II
Partner - Master II

to know if a field has selections or not use GetSelectedCount(Field)

I can walk on water when it freezes
Gysbert_Wassenaar

if(not getselectedcount([Fiscal Year]) and not getselectedcount([Fiscal Month]), ...true..., ...false... )


talk is cheap, supply exceeds demand