calculation in straight table

[krishna20]

Hai Friends,

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

i am uploading sample data and qvw

[MK_QSL]

What is the logic behind your requirements?

[krishna20]

Thanks for your quick reply

the logic behind this requirement is

we need to calculate the value when user select the period

[MarcoWedel]

maybe helpful:

QlikCommunity Tip: How to get answers to your post?

Its not about the answer, rather it’s about the question…

regards

Marco

[krishna20]

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