Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ramanarayan
Contributor

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.

 

Tags (1)
Labels (1)
5 Replies

Re: Question on straight table selection

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

Re: Question on straight table selection

sorry i missed. Attached now

sohailansari201
Contributor

Re: Question on straight table selection

Please see if this helps you. (QVW Attached)

bharani8
Contributor III

Re: Question on straight table selection

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

sohailansari201
Contributor

Re: Question on straight table selection

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.