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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data selection where

Dear community!

I am struggling with a formular which gives me a certain date under certain conditions.

The two formulars (because two fields) look as followed at the moment:

1) if(DABMG.EKET and WEMNG.EKET = 0,min([EINDT.EKES]))

2) if(WEMNG.EKET < DABMG.EKET,aggr(min([EINDT.EKES]),%MATNR)) --> this is another trial, because in the table I do have one line per materialnumber.

So if the both fields contain zero, the min date should be shown in the table, otherwise nothing should be written into the field.

Thank you a lot for your ideas!

Regards,

Barbara

Labels (1)
1 Reply
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Could u share sample data ?

-Nagarjun