Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Only show a specific value in Table chart.

Hi,

I am trying to create a chart that only shows a specific value from a field.  For example a field "type" might have Declassified and Open.  How can i make it so that table chart only shows Open?  Is this possible without having to click in the field "Type."

Thank you for your help,

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Only show a specific value in Table chart.

Yes, you can supply additional conditions, for example:

IF(Type='Open' And Color='Red',Type)

7 Replies
erich_shiino
Honored Contributor

Re: Only show a specific value in Table chart.

Hi,

You can use set analysis in all you expressions.

For example, if your expressions are sum( Value) and sum (Qtd)

The adjusted expressions are sum ( {<type={Open}>}  Value ) and sum ( {<type={Open}>}  Qtd)

Hope it helps,

Erich

Not applicable

Re: Only show a specific value in Table chart.

You could also specify an expression for your dimension in a straight table chart, i.e.

IF(Type='Open',Type)

Then select to Supress when it's Null

See attached.

Not applicable

Re: Only show a specific value in Table chart.

Thanks,

That works, but I still get these '-' marks that changes the table chart.  How can i get rid of those as well?

The first part works great.

Not applicable

Re: Only show a specific value in Table chart.

I clicked on supress null value and it worked to get rid of the '-'.    Can one add multiple variables. For instance, Type = open and color=red?

Not applicable

Re: Only show a specific value in Table chart.

Yes, you can supply additional conditions, for example:

IF(Type='Open' And Color='Red',Type)

erich_shiino
Honored Contributor

Re: Only show a specific value in Table chart.

Hi,

On set analysis you can also use multiple filters:

sum ( {<type={Open}, Color={Red}>}  Qtd)

or

sum ( {<type={Open}, Color={Red, Blue}>}  Qtd) -> meaning, type equals to Open and (Color equals to Red or Blue)

Regards,

Erich

Not applicable

Re: Only show a specific value in Table chart.

Thank you very much.  It is working great. 

Thank you Erich as well.  Your solution works as well.

Nicholas

Community Browser