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: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

How to only display specific text in results?

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

9 Replies
hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Any help on this?

Not applicable

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.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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.

Not applicable

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

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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

Not applicable

"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

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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?

Not applicable

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.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Oh ok, i understand now..

Thanks for all your help 🙂