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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

AGGR HELP

Hi

Need help to derive aggr expression by dropping one values of the filed attached herewith the data

Thanking You

Vinayagam

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

Like this?

If(CATEGORY='DS', FieldValue('DAYS',1), DAYS) as NewDAYS

View solution in original post

4 Replies
tresB
Champion III
Champion III

Like this?

If(CATEGORY='DS', FieldValue('DAYS',1), DAYS) as NewDAYS

Anonymous
Not applicable
Author

hi tresesco thanks for the spontaneous reply but in my real data model the days filed is from another table and i cant merge it in a single table can pls suggest how to derive the same using fronted expression

Thanking you

Vinayagam

tresB
Champion III
Champion III

PFA

jagan
Partner - Champion III
Partner - Champion III

Hi,

If you attach some sample with both the tables then it would be easier to solve this.

Regards,

Jagan.