topic Re: How to copy an Expression from a Straight Table to Pivot table. in QlikView

How to copy an Expression from a Straight Table to Pivot table.

Thu, 25 Jun 2015 13:36:29 GMT

Hello,

I have an expression derived from other 4 expressions in a straight table. I want to use only this derived expression in a pivot table.

Is there a way to copy this expression over in the new pivot table?

I was searching for 2 options:1) copy all those base expressions and hide them (but not sure how to hide them and still be able to use their values in this derived expression.

2) a way to copy only this derived expression from the Straight table.

Thanks a bucnh for your time and help.

Re: How to copy an Expression from a Straight Table to Pivot table.

alexandros17 — Thu, 25 Jun 2015 13:45:19 GMT

No way to hide expressions in pivot table (if you use the condition box the column's value is not accessible).

No way to use the derived expression (you can copy it but obviously other values are in the other table)

I think you cannot follow this way ...

create an expression by mixing all the other and copy it in the new table

Re: How to copy an Expression from a Straight Table to Pivot table.

Colin-Albert — Thu, 25 Jun 2015 13:48:07 GMT

Two options:

1. Copy the expressions one by one from the straight table to the pivot table;

2. Clone the straight table and change the chart type of the cloned copy to a pivot table, this may require you to change to the dimensions if they are not the same.

Either way you cannot hide expression in a pivot table.

Re: How to copy an Expression from a Straight Table to Pivot table.

Thu, 25 Jun 2015 13:52:46 GMT

Copying is tough to do because i have 3 expressions , 1 derived from these 3 and 5th one (which i need to use in other table) is derived from all the other 4 expressions.

Re: How to copy an Expression from a Straight Table to Pivot table.

Thu, 25 Jun 2015 15:06:57 GMT

Hi Colin,

Thats exactly what I have done now, but that still doesnt help to get rid of the expressions i dont want to include.

So looks like there is no way to do either of the two options ?

any other method to conditionally hide a column from the pivot table?

Re: How to copy an Expression from a Straight Table to Pivot table.

b_garside — Thu, 25 Jun 2015 15:18:01 GMT

Yes you can try conditional check box. Just make sure you have at least one always enabled.

Re: How to copy an Expression from a Straight Table to Pivot table.

Thu, 25 Jun 2015 15:31:00 GMT

Can you help me with the specific condition that I need to write in order to hide the column?

Thanks

Re: How to copy an Expression from a Straight Table to Pivot table.

b_garside — Thu, 25 Jun 2015 15:52:45 GMT

Well it can be many things dependent on your requirements. try to have it result in a binary 1=true / false 0

If(condition is true, 1,0 )

Wildmatch(String,'1','2','3') > 0

Re: How to copy an Expression from a Straight Table to Pivot table.

Thu, 25 Jun 2015 20:11:22 GMT

Hi Brian,

I am sorry I still dont follow, I understand we would want to specify bolean values.

But what would be a If(condition is true, 1,0 ) in this case that Qlikview will interpret that "should hide" the expressions correctly?

Re: How to copy an Expression from a Straight Table to Pivot table.

b_garside — Thu, 25 Jun 2015 20:15:13 GMT

Correct. Within the if statement you may have criteria to determine selections are made, etc to check against if they are met, then it results in a 1 for enabled. Or may be a simple Count(Sales) > 1000 which would result in a true false and allow expression. Endless possibilities. I cant write it unless I know what they are.