topic Re: ignore calculated dimension in QlikView

ignore calculated dimension

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

Hi,

I have a straight table comparing current year submission amount and another expression previous year submission amount.

I have dimension something like below

Country,

Client,

=Aggr(Only({<Period={"$(=Period)"}>} Submission Date), Submission Date)

problem is after adding the submission date for current year, the previous year submission amount is not populating.

but if i disable calculated dimension highlighted above then the expression is calculating,

how to ignore this calculated dimension or can i use it as expression???

Gautham

Re: ignore calculated dimension

gauthamchilled — Fri, 24 Nov 2017 05:22:32 GMT

Any help?

Re: ignore calculated dimension

avinashelite — Fri, 24 Nov 2017 05:37:28 GMT

if I understood properly your trying to get the submission data for current and previous year on the Date column ....since the date is current year it will not ignore the dimension selection ...if you use any other dimension except the submission date your approach will work.....if you need Submission date as dimension then you need to make use of Asof table and get the required flag/column to achieve this ..

The As-Of Table

Re: ignore calculated dimension

jonathandienst — Fri, 24 Nov 2017 05:55:04 GMT

If Period has more than one possible value, your expression will null out because $(=Period) will evaluate to null. If Period is a dimension, then this approach will not work. If however, you want all the dates within the selected period, then something like

=Aggr(Only({<Period={"$(=Max(Period))"}>} Submission Date), Submission Date)

should work and will return the selected period, or the most recent if nothing is selected.

Re: ignore calculated dimension

dinuwanbr — Fri, 24 Nov 2017 06:08:10 GMT

Hi,

Is it possible for you to upload a sample for better understanding?

BR,

Tharindu

Re: ignore calculated dimension

gauthamchilled — Fri, 24 Nov 2017 09:18:42 GMT

Thanks all for the help..i attached an application with dummy data..but the issue is almost similar.

If i add the submission date for current year, i am not getting sales in first column.

please help

Re: ignore calculated dimension

gauthamchilled — Fri, 24 Nov 2017 14:30:11 GMT

can anyone please help?

Gautham

Re: ignore calculated dimension

settu_periasamy — Fri, 24 Nov 2017 15:04:06 GMT

Maybe Like Attached

Re: ignore calculated dimension

Anonymous — Fri, 24 Nov 2017 15:15:12 GMT

Settu's answer looks good. Otherwise you can make the Submission Date an expression.

If it's an actual date field it would be max(Submission Date)

If it's a string column it would be maxstring(Submission Date)

Re: ignore calculated dimension

gauthamchilled — Fri, 24 Nov 2017 16:25:33 GMT

It didnt work in my actual application, still it shows 0.

Re: ignore calculated dimension

settu_periasamy — Fri, 24 Nov 2017 17:03:52 GMT

Can you provide the sample, replica of your original application?

Re: ignore calculated dimension

Anil_Babu_Samineni — Sun, 26 Nov 2017 13:22:35 GMT

Looks Like Concatenate Issue over model

Re: ignore calculated dimension

rubenmarin — Sun, 26 Nov 2017 19:55:14 GMT

Hi Gautham, not sure but seems that first column is related with the calculated dimension, the second is not.

Maybe adding a set analysis to the 2nd expression to ignore [Submission Date] and setting the calculated dimension to supress null values.

If ignoring dimension doesn't works you can try adding a "TOTAL <Country, Customer>" clause to the 2nd expression.