Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Want to Create the Field in Data Model

Hi i am having the Requirement to add the Dimension in the Ad hoc Report

1.M Comments

2.Scomments

Based on below two column i need to create the (M Comments & S Comments )field in the Data Model

1.A Comments

2.Sub type

Req1: if sub type ='Supliment' ,it should return the relavent A comments -->Need to create it as field .

michaelwadloveisfailjimhalpertafderikabghnick2009theresaa

1 Solution

Accepted Solutions
olivierrobin
Specialist III
Specialist III

hello

why don't you use in your load

if( sub type ='Supliment',[A Comments],other value) as (M Comments & S Comments )

View solution in original post

1 Reply
olivierrobin
Specialist III
Specialist III

hello

why don't you use in your load

if( sub type ='Supliment',[A Comments],other value) as (M Comments & S Comments )