topic Re: Trying to select only certain values in calculated expression of pivot table. in QlikView

Trying to select only certain values in calculated expression of pivot table.

Tue, 17 Sep 2013 17:38:25 GMT

Hi community,

I was wondering if there was a way to select only certain values of a column in a pivot table. The expression for that column is something like "if another column in the table is greater than a certain amount, then 1 else 0." Any help would be appreciated.

Re: Trying to select only certain values in calculated expression of pivot table.

v_iyyappan — Tue, 17 Sep 2013 17:58:27 GMT

Hi,

Can you please share sample file for that?

Regards,

Re: Trying to select only certain values in calculated expression of pivot table.

Gysbert_Wassenaar — Wed, 18 Sep 2013 11:41:39 GMT

You can't select expression values in a pivot table (or any other object). What that will do is select the dimension values of that row.

Re: Trying to select only certain values in calculated expression of pivot table.

abeyphilip — Wed, 18 Sep 2013 12:15:39 GMT

Hi Brandon,

As G Wassenaar suggested you will not be able to select values of an expression. However, you can achieve the same by creating a list box with field as expression similar to the one you were selecting in the pivot.

"if another column in the table is greater than a certain amount, then 1 else 0."

For this you will have to include the expression for the "another column" and the evaluate it to 1 or 0. List box will then have two entries 1, 0 and selecting the same will give you the result same selecting the expression value on pivot.

Regards,

Abey

Re: Trying to select only certain values in calculated expression of pivot table.

sathishkumar_go — Wed, 18 Sep 2013 12:36:37 GMT

HI Brandon,

Please find the attached file.

I hope the attched file will match your requirement.

Regards

Sathish