topic Re: Question on straight table selection in QlikView

Question on straight table selection

ramanarayan — Sat, 16 Nov 2024 05:00:39 GMT

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.

Re: Question on straight table selection

sunny_talwar — Mon, 10 Dec 2018 14:52:48 GMT

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

Re: Question on straight table selection

ramanarayan — Mon, 10 Dec 2018 15:03:30 GMT

sorry i missed. Attached now

Re: Question on straight table selection

sohailansari201 — Wed, 12 Dec 2018 22:15:02 GMT

Please see if this helps you. (QVW Attached)

Re: Question on straight table selection

bharani8 — Thu, 13 Dec 2018 06:56:04 GMT

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

Re: Question on straight table selection

sohailansari201 — Thu, 13 Dec 2018 15:30:26 GMT

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.