Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ebrahimaljefri
New Contributor III

multiple Conditions set analysis

hi qlikers

i have used if conditon and it works but i want to make multiple Conditions in set analysis and also want to specified time  :

Count(if(DownPaymentDate2<>CreatedDate,DownPaymentDate2))

note i have not specified time in if condition

Tags (2)
3 Replies
sureshqv
Esteemed Contributor III

Re: multiple Conditions set analysis

what is the time format?

example like below you can use

count({<[TIME] = {">$(=TimeStamp(ReloadTime()-3, 'DD.MM.YYYY hh:mm:ss TT'))"} >}, if(DownPaymentDate2<>CreatedDate,DownPaymentDate2))

ebrahimaljefri
New Contributor III

Re: multiple Conditions set analysis

only consider month and year format   "MM/YYYY"

giakoum
Honored Contributor II

Re: multiple Conditions set analysis

You should do the if in your reload script

Community Browser