Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Specialist III
Specialist III

Re: Want to Create the Field in Data Model

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
Highlighted
Specialist III
Specialist III

Re: Want to Create the Field in Data Model

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