Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Highlighted

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.