- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression in Straight Table
Hi All,
I have 10 fields in a list box by writing an load * inline statement. I have written the below expression in the straight table chart
=sum(IB_1)
Now my problem is,this expression should be changed whenever i select a field(Flag) the expression should be changed to sum(IB).
If i un-select flag then it should be changed to sum(IB_1).
Attached qvw for reference.
Is it possible to achieve.
Thanks,
Bharat
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
=If(SubStringCount('|' & Concat(distinct Dimension2, '|') & '|', '|Flag|'), Sum(IB), Sum(IB_1))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
=If(SubStringCount('|' & Concat(distinct Dimension2, '|') & '|', '|Flag|'), Sum(IB), Sum(IB_1))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Bharat,
If I understand your requirement correctly here is the solution.
Please find attached qvw
Regards,
Mayank !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Sunny....You are just Awesome...
One more thing after writing this expression based on the month selection the value should effect.
For example: if i select jan the value should be (expression)/1 , if i select feb (expression)/2 , if i select march (expression)/3 if i april (expression)/4.. Can you please tell me how to achieve this..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
=If(SubStringCount('|' & Concat(distinct Dimension2, '|') & '|', '|Flag|'), Sum(IB), Sum(IB_1))/Month(Period_NR)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Genius.. Sorry Missed the trick..