Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help - formula with or in set analisys

Hi guys,

Please help me to translate this formula in set analisys mode, i don't know how i can do it.

this is the formula :

count({$<flag_tipo_data= {ifas},id_fas= {1},Anno=,Mese=,Giorno=,data_short=,Settimana=>} distinct if(FakeData=fake_dt_hi,

if(dt_in_fas_num <= date_hi and (date_hi< dt_out_fas_num or IsNull(dt_out_fas_num)),id_e2e) ,

if(( FakeData< fake_dt_out_fas or IsNull(dt_out_fas_num)) and FakeData >= fake_dt_in_fas,id_e2e) ))

I wrote in bold the fileds which are Variable.

thx a lot for you support.

Bye.

1 Reply
IAMDV
Master II
Master II

Tinamus - If possible, please can you load a QV document with sample data? We can convert your expression into set analysis but we need to test the same. Also it will be very useful to write your requirement in general english, it helps other users to understand quickly.

Cheers - DV