topic Re: Access a calculated column in QlikView

Access a calculated column

Wed, 25 Nov 2020 16:16:04 GMT

I want to know if anybody has an idea of how to access column of a calculated column. If it is part of the loaded table, its not an issue. I tried accessing it using various syntax's given online. Can i use the label of the calculated column. Example, if the calculated column label is "total", how to access it. Thank you in advance!!

Re: Access a calculated column

Oleg_Troyansky — Wed, 12 Oct 2016 19:06:59 GMT

Hi,

you should clarify your question a bit... how do you want to access the column, and where from?

Some thoughts:

- Within the same chart, calculated columns (Expressions) can be referenced in other Expressions by their name (Label) or number, using the function Column(x).

- Outside of the same chart, calculated columns can't be accessed from other charts.

- Calculations that are not "dimensional", can be performed using a variable with a formula that begins with an equal sign.

If these answers don't cover your question, then please clarify your needs in more details.

cheers,

Oleg Troyansky

Learn advanced techniques for QlikView and Qlik Sense in my book QlikView Your Business.

Re: Access a calculated column

Wed, 12 Oct 2016 19:18:45 GMT

Hi. Thanks for your reply. There is an expression/new column (say Column1) in my chart object like [ if(x>0 and y<0 and z=1, 1,0). So i have a new column with values of 1 or 0 based on condition. Now outside this chart, i need a method to filter data, for example some way i can filter and show only those data for which i have assigned 1 in the chart. This should be done , if a user selects a yes/no in a dropdown for filter Column1 data . If he selects yes, i need to display only those values in column1 that have "1" in them

Re: Access a calculated column

Oleg_Troyansky — Wed, 12 Oct 2016 20:24:53 GMT

Hi,

you can't reference the columns outside of the chart. I'd consider placing your calculation in a calculated List Box.

cheers,

Oleg Troyansky

Re: Access a calculated column

vinieme12 — Wed, 12 Oct 2016 20:26:12 GMT

Nope , you can't on the dashboard .

Create the calculated column in your script.

Re: Access a calculated column

Wed, 12 Oct 2016 21:13:18 GMT

Can i reference the value in a calculated column within that table. If so, how ? How do i access the values of the calculated column in each row. Can we access it using the column name(calculated column name)?

Re: Access a calculated column

Anil_Babu_Samineni — Thu, 13 Oct 2016 01:19:03 GMT

One solution might be

Create one more online with the values of 1,0 and then join them.

Then create mapping for new directory so that use apply map from New to existing table

Re: Access a calculated column

qliksus — Thu, 13 Oct 2016 06:58:52 GMT

Why cant you simply clone the chart and make it as a Straight table with only the column you want to filter . Hide all other columns you don't want to display something like the below and use this calculation in a variable to refer it in other charts

Re: Access a calculated column

vinieme12 — Fri, 14 Oct 2016 05:52:24 GMT

Yes, there are two ways to do that, these apply to Expressions only

1) Refer column using column number ,: Column(1)

2) Refer using the Name :

Qlik Tips: Performance using Labels or Column() in charts

Reusing expressions — chart column references | Qlikview Cookbook

Re: Access a calculated column

Fri, 14 Oct 2016 15:13:01 GMT

I placed the calculation in a calculated list box and I am facing an issue in that. I am placing two conditions with an YES/NO. The data is filtered correctly according to my selection. But the selection i make (ie. YES/NO) is disappearing when i click it( it does not stay highlighted). The user will not know if YES/ NO is selected. It is working like a trigger. Once I click yes, data s filtered but the yes does not stay highlighted. Why does this happen?

Re: Access a calculated column

Oleg_Troyansky — Sat, 15 Oct 2016 17:39:12 GMT

It's really hard to imagine what's happening without seeing the app. If you can't share your app, create a small model that illustrates your problem, and share it.

In the calculated List Box, try using the AGGR() function with your calculation, maybe it works better.

Re: Access a calculated column

vinieme12 — Sun, 16 Oct 2016 07:11:04 GMT

Try like this

Aggr(only({1} yourcalculation) , dimension)