Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to only display specific text in my straight table results.
I have an app which shows all stock movements . My stock movement descriptions are :
WASTE Standard
WASTE Reduced RSP
Waste Newspaper Write-offs
P/O Price Errors
P/O Short Dated
P/O Damages
STKADJ Stolen
STKADJ Freezer/Dairy Breakdown
STKADJ Transfers in
STKADJ Transfers Out
etc
In my app, i have a minimised straight table for the following
Wastage
OverRides
Stock Adjustments
Stock Variances
What i want to do, is when the user maximises the Wastage straight table, only WASTAGE reasons to be displayed, i.e. any stock movement descriptions starting with WASTE.
When OverRides is selected, any stock movement descriptions starting with P/O
etc..
My Stock Movement Description field is called 'Narrative'
Any help would be appreciated.
Hi, now i understand what you can see.
You can define a calculated dimension, and use a temporary table to set the group that you want to demonstrate in your Straight Table
Any help on this?
Hi,
You can define a flag for each row in your table 'Narrative':
Ex.:
1, Wastage
2, OverRides
3, Stock Adjustments
4, Stock Variances
When selected a values of 'narrative', you can define in tab "Presentation" / "CONDITIONAL" if the column willl be hide or not.
Hi, I am not sure if i understand what your saying or if you have missunderstood me...
This is a screenshot of my straight table,
As you can see it shows P/O short dated and waste standard.
I only want it to show Waste Standard without having to make any selections.
I am assuming i can write an expression using set analysis, but i am not sure what the expression would need to be.
Hi, now i understand what you can see.
You can define a calculated dimension, and use a temporary table to set the group that you want to demonstrate in your Straight Table
Hi Eduardo,
Thanks, that seems to work 🙂
But could you explain What it means please?
I know what the IF((Narrative = 'Wastage' part means, but am unsure what the rest means...
AND UPPER(ReasonDescription) like 'WASTE*'),
Thanks
"UPPER(ReasonDescription) like 'WASTE*')"
This code verify all values from "ReasonDescription" that start with "WASTE".
How in your field have some values that Start with WASTE, the condition return TRUE.
Ex.:
WASTE Standard
WASTE Reduced RSP
Waste Newspaper Write-offs
All rows start with WASTE, and the simbol * ignore string that exists after.
You can see more in Advanced Search
Sorry, but my english os not good.
Thanks
Hi,
I understand that now, But why would i need to specify the Narrative AND ReasonDescription?
I have tried using
=IF((Narrative like 'P/O*' ), ReasonDescription)
Which brings back the same result. Can you see a problem with using this instead?
In my example, i create two tables.
I put the code just to demonstrate the function, because i don't know how are your model.
Oh ok, i understand now..
Thanks for all your help 🙂