topic Re: Hide Dimension Straight Table in QlikView

Hide Dimension Straight Table

Tue, 13 Jun 2017 20:58:47 GMT

Hi,

I'd like to hide a dimension in a straight table; I need it to pull back data for that dimension, but I don't actually need it to show on my bar chart...is that possible?

Thanks

Re: Hide Dimension Straight Table

el_aprendiz111 — Tue, 13 Jun 2017 21:06:18 GMT

Hi,

Macro:

sub HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
end sub

sub HideCol
call HideColumn("CH23", 2)
end sub

Re: Hide Dimension Straight Table

Peter_Cammaert — Tue, 13 Jun 2017 21:11:03 GMT

Is it a straight table or a bar chart? They each have different properties that can be enabled/disabled...

In a straight table, you can show/hide any column by selecting the column in the Presentation tab and enabling the "Hide column" radio button. Note that you may get seemingly identical rows in your straight table, as the dimension column will be hidden but its values may still make a difference and split your rows.

Re: Hide Dimension Straight Table

ahaahaaha — Wed, 14 Jun 2017 07:22:50 GMT

Hi,

On the histogram, you can hide the legend

Re: Hide Dimension Straight Table

chhavi376 — Wed, 14 Jun 2017 07:36:11 GMT

Hi Nicole,

If you want an impact of a dimension in a chart, you can also use set analysis in the expressions for that.

You can refer to the following links to learn more about that:

Set analysis and set expressions ‒ QlikView

https://community.qlik.com/docs/DOC-4951

Rest, it would be great if you could share a screenshot/application so that we can understand your question in a better way.

Regards,

Chhavi.

Re: Hide Dimension Straight Table

Wed, 14 Jun 2017 14:39:59 GMT

Thank you! My question is both for the straight table and the bar chart:

1. On the straight table, even after I hide the column, it is showing all the individual amounts below the sum. Is there any way that I can just see the sum?

2. On the bar chart, I'm unsure of how to hide it...it's affecting my bar chart as well. I want only to show YTD 17 sales and YTD 16 sales, but the issue is that it's showing me every single bar because all of the individual amounts are still there. Is there any workaround to that?

Re: Hide Dimension Straight Table

Wed, 14 Jun 2017 14:40:39 GMT

Hi Fer Fer,

Thank you for this, but this is a little above my understanding; where would I input this?

Re: Hide Dimension Straight Table

el_aprendiz111 — Wed, 14 Jun 2017 16:16:54 GMT

Hi,

1 Example (Ctrl +M)

Re: Hide Dimension Straight Table

passionate — Wed, 14 Jun 2017 16:23:24 GMT

Hi Nicole,

In straight table you have option to hide dimension directly.

In Bar Chart you can enter Zero in Enable condition In Dimension.

Re: Hide Dimension Straight Table

Wed, 14 Jun 2017 17:47:58 GMT

Thanks Pakaj! I still need this dimension to restrict the sales number though, would you know how I make this dimension a part of set analysis? Here's my dimensions and expressions. I need to move TXN Type out of dimensions--

Dimensions:

1. Item Type:

=if (Match([Transactions.Item Type], 'InventoryItem') and

Match([Transactions.Txn Type], 'Invoice','Sales Receipt', 'Credit Memo', 'Charge', 'ARRefundCreditCard'), [Transactions.Item Type])

2. TXN Type:

=if(([Transactions.Inventory Table] = 0) and (Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Match([Transactions.Txn Type], 'Invoice','Sales Receipt', 'Credit Memo', 'Charge', 'ARRefundCreditCard'), [Transactions.Line Items Txn Type])

Expressions:

1. 2017 YTD Sales

Sum({$ <[Transactions.Txn Date]={"$(='>=' & Date(YearStart(Max([Transactions.Txn Date])), 'MM/DD/YYYY') & '<=' & Date((Max([Transactions.Txn Date])), 'MM/DD/YYYY'))"}>} [Transactions.Amount])

2. 2016 YTD Sales

=Sum({$ <[Transactions.Txn Date]={"$(='>=' & Date(YearStart(Max([Transactions.Txn Date]),-1), 'MM/DD/YYYY') & '<=' & Date(addyears(Max([Transactions.Txn Date]),-1), 'MM/DD/YYYY'))"}>} [Transactions.Amount])