Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
How to remove the Unique values from Dimension level in qlik.I need only Duplicate Values.
stalwar1 kush141087 loveisfail
Regards
Mahesh
Hahahahaha how you want to see it? For instance you have this
Dim Value
A 10
A 20
B 30
B 30
What are you hoping to see as your result?
MY SAMPLE DATA
1,A,100
2,B,200
3,A,300
4,D,400
5,D,500
6,E,600
7,F,700
o/p:-
A,400
D,900
May be this
Dimension
DimensionField
Expression
Sum({<DimensionField = {"=Count(DimensionField) >= 2"}>}ValueField)
i have 10 dimensions bro
So? What am I missing?
i have to restrict the data in dimension level only.
I am not sure I follow.... you want to use calculated dimension?
1,A,100
2,B,200
3,A,300
4,D,400
5,D,500
6,E,600
7,F,700
o/p:-
A,400
D,900
Here how can i use calculation condition on product for only duplicates.
Here how can i use calculation condition on product for only duplicates.
What does this even mean Mahesh? I gave you dimension and expression... which should give you the desired output... I have no idea what else are you looking for... you have to elaborate a little bit more here... else we won't be able to offer any help
Hi Bro ,Thanks
i got it
=Aggr(if(count(PRODUCT)>=2,PRODUCT),PRODUCT)
mahesh