Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Distinct date values to the same dimension

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

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

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

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

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.

Highlighted
Creator
Creator

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

View solution in original post

Highlighted
Creator III
Creator III

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

Highlighted
Creator
Creator

Glad it helped and sure.

Cheers!