topic Re: Straight Table in QlikView

Straight Table

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi, Please find the attached Qvw file.

I have a dimension "Year",In the Expression tab i have multiple Expressions.

When i click on 2005 it has to be display 2001 to 2005 years data

when i click on 2006 it has to be display 2002 to 2006 years data.the condition should be given in Calculated dimension only.

I have added sample file.Please help me to do.

Thanks

Re: Straight Table

sasiparupudi1 — Mon, 13 Jun 2016 08:50:10 GMT

=ValueLoop(Year-5,Year,1)

Re: Straight Table

bhavvibudagam — Mon, 13 Jun 2016 09:21:47 GMT

Thanks for reply but not working

Re: Straight Table

Anonymous — Mon, 13 Jun 2016 09:29:12 GMT

you can use your calculated Dimension, but you must define in Expression [<Year=>}

otherwise you will only get 1 year

alternatively you can try this Expression:

=Sum({<Year={'>=$(=max(Year-4))<=max(Year)'}>}[Claim Value])

Re: Straight Table

tresB — Mon, 13 Jun 2016 09:31:28 GMT

Bhavvi b wrote:

....the condition should be given in Calculated dimension only.

Why so? Do you have a specific reason for that? Why not in the expression itself?

Re: Straight Table

varshavig12 — Mon, 13 Jun 2016 09:36:32 GMT

Try this.

sum({<Year={"<=$(=max(Year)) >$(=AddYears(max(Year),-4))"} >} Sale_Amount)

Re: Straight Table

sasiparupudi1 — Mon, 13 Jun 2016 09:40:24 GMT

Check this attachement.. It needs Year Selection

Re: Straight Table

sasikanth — Mon, 13 Jun 2016 09:48:36 GMT

HI,

You will always get only one value if you select in Listbox,

as an alternative you can get the same if you select the year through Slider

PFA

Thanks

sasi

Re: Straight Table

florentina_doga — Mon, 13 Jun 2016 09:55:23 GMT

or use

sum({

<Year=e({<Year=({'$(=$(vEnd+1))'})>} Year)>

}

[Claim Value])

Re: Straight Table

bhavvibudagam — Mon, 13 Jun 2016 10:18:17 GMT

Hi sasidhar,

If we select the year it is showing last five years.But it is showing error in calculated dimension without any selections and in all the years the value is same.In the previous file their is only 100 for all the years now i have updated the file with different values now you can find the issue.Please review the below file once.

Re: Straight Table

sasiparupudi1 — Mon, 13 Jun 2016 10:21:59 GMT

You can may be put a condition

GetSelectedCount(Year)>0

in the enable Conditional dialogue box?

Re: Straight Table

pho3nix90 — Mon, 13 Jun 2016 11:41:05 GMT

Is there any specific reason why this has to be done in dimension? This is not possible as far as I know to overwrite selections (IE set analysis) in dimensions, this will have to be done in expression.

Please see attached.

Re: Straight Table

bhavvibudagam — Mon, 13 Jun 2016 14:01:12 GMT

Its working by making small change

=Count({<ACCIDENT_Year = {'>=$(=Max(ACCIDENT_Year)-4)<=$(=Max(ACCIDENT_Year))'}>}CASE_NUMBER)