Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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
Glad it helped and sure.
Cheers!