topic Re: Make first 3 dimensions fixed in pivot table while rest of data is dynamic in QlikView

Make first 3 dimensions fixed in pivot table while rest of data is dynamic

Mon, 26 Jan 2015 07:36:01 GMT

Hi,

How do i fixed the first 3 columns of a pivot tables (which are dimension) where the rest can be filtered.

For the example above, headers 1,2 and 3 will be fixed where else header 4, 5 and 6 depends on the selection.

Attached my dashboard where Case Logs is the tab to find this behavior.

Please kindly help on this.

Thanks

Chun Wey

alexandros17 — Mon, 26 Jan 2015 07:51:10 GMT

In your expressions use an if condition like this (In the expression and in the label):

If(GetFieldSelections(myField)='Value1',

Expression1,

Expression2)

In the label

If(GetFieldSelections(myField)='Value1',

Label1,

Label2)

Let me know

Mon, 26 Jan 2015 08:41:11 GMT

Hi Alessandro,

Thanks for helping in this.

Can kindly explain further on this?

Thanks

Chun Wey

alexandros17 — Mon, 26 Jan 2015 08:53:42 GMT

This is my example

Mon, 26 Jan 2015 09:22:05 GMT

Hi Alessandro,

Attached is my qvw, i still cannot solve.

Under Case Logs Tab, when I click on Tan Senior Resident, the table dis-align. When clicking on John Lee, it works.

Thank you.

alexandros17 — Mon, 26 Jan 2015 09:33:03 GMT

This is because there are no value linked

Mon, 26 Jan 2015 09:39:04 GMT

Hi Alessandro,

If there are no value linked, it means there is no way for this.

So should i don show the resident that has no value linked at the start ? If yes, can advice how to go about this?

Thanks

Chun Wey