topic Re: Hide columns in a straight table in QlikView

Hide columns in a straight table

Tue, 23 Jun 2015 09:54:55 GMT

HI all,

I am new to qlikview and have a straight table that shows product cost for every month. When i make selections in the Listbox i want the straight table to only show the choises that i have made. For example, if i chose June in the listbox the straighttable shold only show the products that were sold in june and the cost for these.

Help would be much appreciated!

Beest regards!

Re: Hide columns in a straight table

santhoo_san — Tue, 23 Jun 2015 10:00:13 GMT

Go to Chart properties > Presentation > Conditional

select each of the expression and put your condition to hide and un-hide

Ex for June : if(getfieldselections(Month)=6,1,0)

Re: Hide columns in a straight table

Anonymous — Tue, 23 Jun 2015 10:04:17 GMT

... or it could be simpler to use a Pivot Table like the attached :

Re: Hide columns in a straight table

awhitfield — Tue, 23 Jun 2015 10:49:00 GMT

Hi Hampus,

change the chart type to a pivot instead!

HTH - Andy

Re: Hide columns in a straight table

Tue, 23 Jun 2015 11:10:13 GMT

Thank you for the response! There's still a problem tho. When i make a single selection of the months it works fine but when i do multiple month selections all columns hide, any thoghts?

best regards!

Re: Hide columns in a straight table

Tue, 23 Jun 2015 11:13:51 GMT

okey nice! what is the if-expression youe have put in the table?

best regards!

Re: Hide columns in a straight table

Anonymous — Tue, 23 Jun 2015 11:15:03 GMT

Hampus

Just checked the qvw that I posted and it works fine for me.

Re: Hide columns in a straight table

Tue, 23 Jun 2015 11:15:18 GMT

You can try : =if(GetSelectedCount(Month)=1,1,0)

Re: Hide columns in a straight table

Tue, 23 Jun 2015 11:18:59 GMT

Got the personal edition of qv at the moment, so cant open other qvw files right now. Shold be fixed until tomorrow tho, would appriciate the if statement:)

Re: Hide columns in a straight table

Anonymous — Tue, 23 Jun 2015 11:24:07 GMT

Hampus

There is no if statement, just do it like this :

Create new Pivot Table
Use Product and Month as Dimensions
Use sum ( Cost ) as Expression
<OK>
Then grab [keep left mouse button down] the Month label, drag over sum ( Cost ) label and drop

Re: Hide columns in a straight table

abhaysingh — Tue, 23 Jun 2015 11:28:12 GMT

Go to presentation select your column u want to hide than you can find option below to that hide column just click it . thanks

Re: Hide columns in a straight table

awhitfield — Wed, 24 Jun 2015 14:31:00 GMT

Hi Hampus, nothing relevant to the issue in hand, was just experimenting with something else on the same table

HTH - Andy