Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
absekrafi
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
achettipalli
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
absekrafi
Creator III
Creator III
Author

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.

achettipalli
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

absekrafi
Creator III
Creator III
Author

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

achettipalli
Creator
Creator

Glad it helped and sure.

Cheers!