Hide & Show Values of A Field

[s10157754]

Dear Qlikview Experts,

May I know what is the correct syntax for me to display and hide a certain values in a field?

Basically I have created a straight table to display my 'Result' Field. If 'BCNo' is 205, then display all values under the 'Result' field. But I only want to see Beta and Delta, so my first expression works as follow:

=Aggr(Only({<BCNo={205},Result={'*e*'}>} Result), Result)

But I also want to hide Beta from showing. So it will only display (Delta)

But I have problem in getting the correct syntax. I have used following expression but it does not work. Any ideas from you all would be greatly appreciated!

=Aggr(Only({<BCNo={205},Result={'*e*'},Result-={'Beta'}>} Result), Result) 

Best Regards

[vishsaggi]

Are you looking for this?

Try this

Result:

LOAD *, Pick(Match(Result, 'Alpha', 'Beta', 'Delta'), 1, 2, 3) AS ResultFlg INLINE [

BCNo, Result

205, Alpha

205, Beta

205, Beta

202, Beta

202, Alpha

202, Alpha

205, Beta

205, Delta

205, Delta

202, Alpha

];

[jonathandienst]

This should do it

=Aggr(Only({<BCNo={205},Result={'Delta'}>} Result), Result)

[s10157754]

Dear Jonathon,

As my system will be updating the raw data in excel sheet automatically everyday, so there will be more than 500 different outputs under 'Result' field. That is why I was looking for correct expression to display all values under 'Result' field for BCNo 205 and I want to hide rows if contained specific value. For example in following case:

Beta

Alpha

Category Case: 0

Category Case: 1

Category Case: 2

...(until Category Case: 500)

Delta

As you can see I have more than 500 different outputs, I can use following expression to display all Category Cases Outputs:

=Aggr(Only({<BCNo={205},Result={'*Category Case:*'}>} Result), Result)

But out of these 500 Category Cases Outputs, I also want to hide certain values from showing, such as 'Category Case: 0' and 'Category Case: 1'. However, I do not have any ideas on how to do this in my expression. Thank you so much for your time!

Best Regards

[s10157754]

Dear Vishwarath,

As my system will be updating the raw data in excel sheet automatically everyday, so there will be more than 500 different outputs under 'Result' field. That is why I was looking for correct expression to display all values under 'Result' field for BCNo 205 and I want to hide rows if contained specific value. For example in following case:

Beta

Alpha

Category Case: 0

Category Case: 1

Category Case: 2

...(until Category Case: 500)

Delta

As you can see I have more than 500 different outputs, I can use following expression to display all Category Cases Outputs:

=Aggr(Only({<BCNo={205},Result={'*Category Case:*'}>} Result), Result)

But out of these 500 Category Cases Outputs, I also want to hide certain values from showing, such as 'Category Case: 0' and 'Category Case: 1'. However, I do not have any ideas on how to do this in my expression. Thank you so much for your time!

Best Regards

[jonathandienst · Accepted solution]

Like this then

=Aggr(Only({<BCNo={205}, Result={'*Category Case:*'}>*<BCNo={205}, Result-={'Category Case: 0', 'Category Case: 1'}>} Result), Result)

The * is an intersection operator. This expression will fetch all Category Case matches except the two listed in bold above.

[s10157754]

Dear Jonathan,

Thank you so much for your help! It works like a charm! Have a good day!

Best Regards