Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

only show a selection of a field

Hi,

This could be a very stupid question, but I have a field which looks like this :

Capture.PNG

I want to make a sheet with only a few of these productgroups...

Is it possible to have the same field showing only a selection of these values visible, like this?

Capture2.PNG

Do I have to do a load inline for this, and use this new field?

thanks!

Tags (1)
2 Replies
Not applicable

Re: only show a selection of a field

you can create another dimension in load script

or

use an expression in lostbox

aadilmadarveet
Valued Contributor

Re: only show a selection of a field

if you have anyting common in them, then flag the limited ones with 1 or 0 and then use the expression like below in the list box.

IF(ProductGroupingFlag = 1, [Product Grouping], Null())

Thanks,

Community Browser