calculation in straight table

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hai Friends,

I have an requirement like calculation on fly when user select date range

i am uploading sample data and qvw

Re: calculation in straight table

MK_QSL — Thu, 12 Jan 2017 08:58:58 GMT

What is the logic behind your requirements?

krishna20 — Thu, 12 Jan 2017 09:06:09 GMT

Thanks for your quick reply

the logic behind this requirement is

we need to calculate the value when user select the period

krishna20 — Mon, 16 Jan 2017 05:38:38 GMT

Thanks for Suggestion ,

The below one is the scenario

Please open the application and select the Month Year from mar 16 to jun 16

now see the input data in table box and arrived data in straight table

for every metric i am calculating formula changes for min selected and max selected during the period selected by user

example:if you take 235863 min start date is 01/03/2016 prev cluster is Negative

and max start date is 01/06/2016 and current cluster is Negative that means there is no change

for calculating change logic is:

Starting cluster==FirstSortedValue(PREVCLUSTER,START_DATE)

ending cluster==FirstSortedValue(CURRCLUSTER,-START_DATE)

change_type:

If(StartingCluster='NULL'and EndingCluster='Negative', 'Negative',

If(StartingCluster='NULL'and EndingCluster='Neutral', 'Neutral',

If(StartingCluster='NULL'and EndingCluster='Positive', 'Positive',

If(StartingCluster='Positive' and EndingCluster='Neutral','Negative',

If(StartingCluster='Positive' and EndingCluster='Negative','Negative',

If(StartingCluster='Neutral' and EndingCluster='Negative','Negative',

If(StartingCluster='Neutral' and EndingCluster='Positive','Positive',

If(StartingCluster='Negative' and EndingCluster='Positive','Positive',

If(StartingCluster='Negative' and EndingCluster='Neutral','Positive',

If(StartingCluster='Neutral' and EndingCluster='Neutral','NC',

If(StartingCluster='Negative' and EndingCluster='Negative','NC',

If(StartingCluster='Positive' and EndingCluster='Positive','NC',

))))))))))))

now i need to calculate percentage of positives and negatives and neutrals