topic Re: Issue in QlikView

Issue

vipingarg23 — Wed, 01 Aug 2018 14:03:56 GMT

Hi Team,

Please find the dummy data as an attachment.

Requirement:

I have one dimension YearQuarter and two expression A1 and B1.

I want to calculate B1 expression in such a way that whatever data i have in A1 for YearQuarter=2016Q1 that should come in B1 for YearQuarter=2016Q2 and whatever data i have in A1 for YearQuarter=2016Q2 that should come in B1 for YearQuarter=2016Q3 and so on.

Can anybody give me the solution?

Thanks for your help!!!!!!!!!

Re: Issue

sunny_talwar — Wed, 01 Aug 2018 14:06:12 GMT

Try this

=Before(Sum({<YearQuarter>}Data)) * Avg(1)

Re: Issue

vishsaggi — Wed, 01 Aug 2018 14:08:59 GMT

may be try this for your B1

= = Before(Sum(Data),1,4)

Re: Issue

sunny_talwar — Wed, 01 Aug 2018 14:10:13 GMT

What are you using 4 for?

Re: Issue

neelamsaroha157 — Wed, 01 Aug 2018 14:10:39 GMT

May be you can create one more transaction table by residenting the table where you have your 'Data' field and just replace the date fields with adding one quarter and renaming field 'data' to 'Data2' and use this field for your second expression.

I hope I was able to explain what I mean to say.

Re: Issue

vishsaggi — Wed, 01 Aug 2018 14:10:48 GMT

Sunny why we have to disregard Dim YearQuarter?

Re: Issue

vishsaggi — Wed, 01 Aug 2018 14:13:16 GMT

Not required sorry.

Just before(Sum(Data)) will suffice.

Re: Issue

neelamsaroha157 — Wed, 01 Aug 2018 14:13:56 GMT

Here is the sample. I have hard coded but you can achieve same with the expressions.

Re: Issue

sunny_talwar — Wed, 01 Aug 2018 14:14:58 GMT

So, you are essentially referring to using The As-Of Table

Re: Issue

sunny_talwar — Wed, 01 Aug 2018 14:15:27 GMT

Just so you still get a value when one or multiple YearQuarter are selected

Re: Issue

vishsaggi — Wed, 01 Aug 2018 14:16:16 GMT

Got it. Tx

Re: Issue

neelamsaroha157 — Wed, 01 Aug 2018 14:17:03 GMT

True, thanks for using the right term

Re: Issue

sunny_talwar — Wed, 01 Aug 2018 14:19:32 GMT

Re: Issue

vipingarg23 — Wed, 01 Aug 2018 15:26:17 GMT

Thanks Sunny for your help.

It is working fine.

Re: Issue

Anonymous — Thu, 02 Aug 2018 00:35:48 GMT

disregard YearQuarter ? where

Re: Issue

vishsaggi — Thu, 02 Aug 2018 02:08:49 GMT

In sunny's expression if you see Yearquarter field in set analysis. Using this field in set analysis will disregard any selections in that field.

Re: Issue

Anonymous — Thu, 02 Aug 2018 02:15:35 GMT

Got it .Thanx.