Discussion Board for collaboration on QlikView Scripting.
My Table 2 dimension is period by month , now i not sort in sequences.
Table 1 and Table 3 is list box , it work fine.
Can some one advise me.
Go to Solution.
May be this as expression?
Aggr(SUM(C_ONHAND_AMT), (Duration1, (NUMERIC, ASCENDING)))
OR, You can try in script level using Dual() like Nested IF Statements
Thank you for your sharing.
I try to put the expression at Table 2 dimension :-
it does not display any thing , where i go wrong ?
This should be an Expression
And, Note - It will work when you have more thatn QV12 versions only. Are you using same?
If your values in Duration1 are all fixed, how about create a table for sorted in script, then use it to sorted your table?
Sorry I have a question, I found that in your example, when I select in list box,the color is not the default green. Could you please tell me how to change that?
Pls go to list box , right click proprity , then go to Tab = Caption , then click on Active caption and change the back ground color.
I have tested your expression , it work fine on Qlik Sense. since you are so good , i like to ask you how to make the Row 1 >60 Mth move to below , display at row "58-60 Mth" .
Below is the sequences generate by QS , which is not correct :-
First of all, You mark yourself only not the correct one.
And, To solve that you must need Dual() function to each ..
Thanks to reply, well, actually I know that the active caption color, maybe I didn't clarify what I want to ask.
I didn't mean the caption of list box, I see that when I select the value of the list box, the color is not default green.
I just want to know how to make that?