Hide columns in a straight table

[#1]

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!

[santhoo_san]

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)

[Anonymous · Accepted solution]

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

[awhitfield]

Hi Hampus,

change the chart type to a pivot instead!

HTH - Andy

[#5]

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!

[#6]

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

best regards!

[Anonymous]

Hampus

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

[#8]

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

[#9]

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:)

[Anonymous]

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