Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gupta_n8
Valued Contributor II

Front End Help Required

HI All,

I need to create ac straight table which uses the input of values from other straight table and calculates accordingly.

I cannot do these calculations at back end  as the expression in first st. table is evaluated from 4 different fact tables which consists of huge amount of data. adn  joining these fact tables hangs my reload.

the sample is as per below image:

sample.PNG

Left hand side table is first straight table , where I am having two dimensions as LOP and GIM number, and two expressions as Past PCA and PCA Date,

Past PCA is the expression which is calculated from fields from 4 facttales. and PCA Date is the max(PCA_DT).

Now I want my output as my second table where LOP should be the dimension and PAST PCA value should be the PAST PCA(from first table) where the PCA Date is maximum for a particular LOP.

SO for 86070, max PCA Date is 6/7/2016, so Past PCA= 3 % and for 88099 max PCA Date is 7/23/2016, so PAST PCA=0%.

Please advise how to get these values at front end .

Regards

Nitin Gupta

4 Replies
Highlighted

Re: Front End Help Required

Would you be able to provide this data in an Excel file?

gupta_n8
Valued Contributor II

Re: Front End Help Required

Hi Sunny,

Actually this data is not an input.

Its just the straight table which is calculated over the data ,

Requirement is to have other staraight table with the outputs of first st table.

elena888
Valued Contributor

Re: Front End Help Required

Hi,

you can try to use Firstsortedvalue:

Dimension: LOP

Expressione: FirstsortedValue( expression for PAST PCA, aggr(max(PCA DT), LOP))

manucamon
Valued Contributor III

Re: Front End Help Required

Hi NItin,

use the expression, with an aggr function for each LOP.

You can calculate your PCA Date correctlly, and get the needed value.

Regards!!

Community Browser