Discussion board where members can learn more about Qlik Sense App Development and Usage.
Need your help. I stuck up with the following situation. Please go through the Attachment for the the Input data and the Expected output.
In my data there are column name as mentioned in the above table. I need the above the based on the following condition.
1.check for the Class = ABC_BRIDGE,
2. check if Char Name=ABC_RELEVANCY and Char Value=Y, then check any Char value like XXX present or not.
3. If no XXX then it's OK, Else Populate the XXX in the report as per above table.
4. populate the mail id's those whose Char Value ='XXX',
5. The mail ID can be obtained based on the ABC_REQUESTER_ID. that means
if([Char Name]='ABC_REQUESTER_ID', [Char Value])
I tried in different approach by doing aggregating of different column, but i failed and i am getting null value for the Email ID column. Please help me in this regard.
Thank you in advance.
assuming you use this for the Char Value column
if(Class='ABC_BRIDGE' and [Char Value]='XXX',[Char Value])
you can use this for the e-mail
if(len(if(Class='ABC_BRIDGE' and [Char Value]='XXX',[Char Value]))>1,MaxString(total <[Material No.]> if([Char Name]='ABC_REQUESTER_ID',[Char Value],0)),0)
but you probably should find the email address for each material no. in the script , and than add it to the table as a field ,
to make your expressions easier
View solution in original post
Thank you lironbaram Very much for your help. I did as per your suggestion and achieved the required output.