Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Displaying data by Filtering the data using same column without using any Filter Pane.

Hi Friends,

Need your help. I stuck up with the following situation. Please go through the Attachment for the the Input data and the Expected output.

  Expected Output  
Material No.ClassChar NameChar ValueMail ID
0161-2857ABC_BRIDGEABC_CROSS_PLANT_STAT_CDXXXNAME1@XYZ.COM
0161-2859ABC_BRIDGEABC_CROSS_PLANT_STAT_CDXXXNAME1@XYZ.COM
0161-2860ABC_BRIDGEABC_"="""036"_CDXXXNAME1@XYZ.COM
13599700ABC_BRIDGEABC_MATERIAL_GROUP_CDXXXNAME2@XYZ.COM
13599700ABC_BRIDGEABC_MATERIAL_TYPE_CDXXXNAME2@XYZ.COM

 

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.

Sanjay

 

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

hi 

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

2 Replies
Highlighted
Partner
Partner

hi 

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

Highlighted
Contributor II
Contributor II

Thank you lironbaram Very much for your help. I did as per your suggestion and achieved the required output.

 

Thank you,

Sanjaya