This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
iam new to qlikview ,currently i have a problem.i want to find the repeated values and print in the text object.
Now i want to print data in the Text object as S001 = 3
Can any one help on this
Thanks & Regards,
View solution in original post
Take this field in list box and check the checkbox Show Frequency
then you will get a values beside it how many times it is repeated,
if you have more than one duplicate, in a textbox maybe
=concat(if(aggr(count(field),field)>1, aggr(field & ' = ' & count(field),field) ), chr(10), field)
load rowno()as id, field;
load * inline [
see attachment for different (easier) solution with a chart
='Repeated :'&Concat(If(Aggr(Count(Field),Field)>1, Field&' Count :'&Aggr(Count(Field),Field)), '|')
Note: This would work for mutiple values as well.
Try like this in Text object
=Concat(Aggr(If(Count(field) > 1,field & '=' & Count(field)), field), ',')
Iam Not able to open the file.
Try this way also i explain with your sample data
LOAD * INLINE [
And on the Text object write expression
=GetFieldSelections(String) &' = '&Count(String)
Thanks for help Its Working fine.