Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
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
Luminary Alumni
Luminary Alumni

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