Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys. Is there a way to use an "IN" statement, like in SQL, inside of Qlikview?
Here's the piece of my expression where I need to use it (I know that my expression isn't complete):
sum(if(apel_ltr_snt_dt - [Received_Date]<=60 and dsft_sevy_ds = 'Standard60' and [Medicare Type] in 'C', 'D', 'W', 'P'
See where I used the "in" at the end?
Can this be done? If so, how would I write it?
Thanks!
We cannot use IN keyword in QlikView as like in SQL.
But you can write the same expression in Set Analysis.
Make sure that Set Analyis should be used with Aggregation functions.
Sum({<apel_ltr_snt_dt-[Received_Date]={"<=60"},dsft_sevy_ds={'Standard60'},[Medicare Type]={'C','D','W','P'}>}XXX)
XXX- Field that you want to calculate sum
Hope this helps
Cheers!!
Like this:
match([Medicare Type], 'C', 'D', 'W', 'P')
We cannot use IN keyword in QlikView as like in SQL.
But you can write the same expression in Set Analysis.
Make sure that Set Analyis should be used with Aggregation functions.
Sum({<apel_ltr_snt_dt-[Received_Date]={"<=60"},dsft_sevy_ds={'Standard60'},[Medicare Type]={'C','D','W','P'}>}XXX)
XXX- Field that you want to calculate sum
Hope this helps
Cheers!!
Thanks guys!