Discussion Board for collaboration related to QlikView App Development.
I have loaded a table which is a transaction table showing the sales by Product,Year,Month ..etc
I have taken two list box ProductID, Year and a text box Year,
I just want to display the years associated with the ProductId when a product is selected, so far that I have used Concat function in the
text box and later got a thought to sort the displayed years in the ext box in descending order but to my strange I am getting the years
twice in the text box.
Please advice what might me wrong.
Iam attaching my sample
Go to Solution.
=' The values selected in year field are' &chr(13)&
Concat(DISTINCT Year,CHR(10),-Aggr(NODISTINCT SUM(Sales),Year))
Concat(DISTINCT Year ,chr(13),-Aggr(NoDistinct Sum(Sales),[Product ID] ,Year))
View solution in original post
Can you throw some light on whats happening with that "NoDistinct" in the Aggr
What is the function of DISTINCT and NODISTINCT in AGGR function?
Qlik Tips: No nodistinct
Thanks for the links