Discussion board where members can get started with QlikView.
I came across the following set of data and I am confused how to actually calculate(write the expression)-
I have a text object which should show total structures-
If account 'abc' is selected so total structures=2+1+5=8
How should i write the expression for this, need help.
maybe, sum(distinct Structures) ?
One way is as below:
I'am not exactly shure which of both works
The above example will work on selection.
But if you want it say on a chart
sum(distinct Structures) would do it; why complicate things?