topic Re: Distinct date values to the same dimension in QlikView

Distinct date values to the same dimension

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

Dear all,

In my fact table I have TRANSACTION_DATE field as a dimension.

I want to display some dimensions from the fact table depending on TRANSACTION_DATE.

So I added 2 dimensions as follow:

=TRANSACTION_DATE='$(vStartDate)'

=TRANSACTION_DATE='$(vEndDate)'

The problem I am facing is that in my straight table I getting the other dimensions fields duplicated and I don't want that.

Please see the enclosed image (please the first, the second.

Please I need your help on that.

Best regards,

Abdallah

Re: Distinct date values to the same dimension

absekrafi — Thu, 25 Oct 2018 14:50:47 GMT

Just to explain more:

I have factory, product and sub-product as dimensions.

I defined an interval as vStartDate and vEndDate.

I want to display, in a straight table, the initial stock and the final stock for each product on the same line.

The way I added to dimensions as above (in the same discussion), I got the factory, the product and the sub-product diplicated.

I would like to know how to fix that.

Re: Distinct date values to the same dimension

achettipalli — Thu, 25 Oct 2018 17:07:46 GMT

Hi Abdallah!

You can write set analysis in the expression field to get the stock count for start date and end date.

Like sum({<TRANSACTION_DATE= {'$(vStartDate)'}>}stockamount).

I believe, you cannot achieve in the same line when adding dates as dimensions, since qlikview does the grouping automatically when you add a dimension field.

So I'd prefer in expressions field.

good luck

Re: Distinct date values to the same dimension

absekrafi — Fri, 26 Oct 2018 08:35:50 GMT

Hi Avinash,

Thank you very much. it's working! Excellent

In addition I don't have to add the transaction date as dimension.

I have another question I will open a new discussion on that.

Best regards,

Abdallah

Re: Distinct date values to the same dimension

achettipalli — Fri, 26 Oct 2018 13:19:59 GMT

Glad it helped and sure.

Cheers!