Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Question on straight table selection

Hi Experts,

I have a list box with Qtr as field and a straight table for sales amount.  

By default, i have customized the straight table to show 3 quarters from the latest quarter when no selection is made.

However, what i need is, when i manually select any quarter from the list box, i need to be able to see the selected quarter + previous 2 quarters as well. 

Need an expression to achieve this please.

Attached is my qvw file.

 

Labels (1)
5 Replies
sunny_talwar

I am not seeing any qvw file attached? Did you forget to attach?
ramanarayan
Creator
Creator
Author

sorry i missed. Attached now

sohailansari201
Creator
Creator

Please see if this helps you. (QVW Attached)

bharani8
Creator III
Creator III

What does Rnk field do here? and on wat basis did u segregate that? Can u plz explain..

sohailansari201
Creator
Creator

Rnk is a simple serial number that starts from 1 for the latest Quarter. This is used in the variables to figure out previous two Quarters. For e.g. if latest Quarter is Q4-2018, then using Rnk 2 and 3, we immediately know that previous two Quarters are Q3-2018 and Q2-2018. Similarly, when user click on any quarter from the list box we get it's Rnk value and then add +1 and +2 to get the previous two quarters. If you look at the variable definitions, it should become more clear. Thank you.