Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the field (A) and I have values B,C,D,E,F. I want to store all the values in the variable.
I am trying to convert
Sum({A = {'B','C','D','E','F'}Sales)
to
Sum({<A = {'$(vtest)'}>}Sales)
Where vtest = {'B','C','D','E','F'}
If I select B, then I should get the data by B else I need to see all the values.
Is this possible?
Thanks,
Varun
May be this
Sum({<A *= {'$(vtest)'}>}Sales)
Hi Sunny,
Thanks for the quick reply.
How can I create the vtest?
vtest = concat('A',',')?
Is there a reason you want to create it using Concat?
If nothing is selected, I wanted to select all the values. If they select the value, I want that value to be selected.
So, why can't you just use this?
Sum({<A *= {'B','C','D','E','F'}>} Sales)
Why do you need Concat?
If new value is added (i.e. If G is added), then it requires the manual effort.
Lol, so why can't you just use Sum(Sales)? When nothing is selected, it will show the sum of sales for all A, but when one A is selected, it will show Sum of sales for just that A. Why do you need set analysis?
Sorry for the confusion. I have renamed the field A as Z and using it in different table. But in the dashboard I am using A as the filter. If I select A, then few values are not displaying. So I thought if we create the variable and use it in the set expression, it will work.
Sum({<Z = {'$(vtest)'}, A>}Sales)
May be you need this?
Sum({<Z = p(A), A>}Sales)