Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Priya10
Contributor
Contributor

If and alternate states

Hi all,

I have an expression as below, which works perfectly fine.

count({Target<Billing_Period=$::Billing_Period>}distinct Matter_InvoiceNum)
+
count({Reference<Billing_Period=$::Billing_Period>}distinct Matter_InvoiceNum)

 

but as soon as it 

wrap the same expression in if or pick match it does not work.

kindly help me with this issue.

 

 

1 Reply
rubenmarin

Hi, it will be better if you post a sample of the expression wrapped, what it returns and what you expect. Even better if you can upload a sample to work with it.