topic Re: show all the columns in a table. in App Development

show all the columns in a table.

rushi1093 — Wed, 27 Apr 2022 07:56:52 GMT

Please help as to how to keep all the fields on the table irrespective of any filters applied...for eg. if I have abc, pqr, xyz value in first column, and their corresponding sales and volume in column in 2 and 3 respectively. So I want to see all abc, pqr, xyz on left(1st columm) whether or not their sales and volume value is zero.

Re: show all the columns in a table.

vinieme12 — Wed, 27 Apr 2022 09:17:10 GMT

The problem is where you are sourcing the dimension from

In such scenario you should be sourcing dimensions from a separate dimension table which has all possible dimension values, like below.

facttable:
Load * Inline [
dimkey,dim2,measure
A,A,10
C,C,5
];

dimensiontable:
Load * Inline [
dimkey,dim
A,A
B,B
C,C
];
exit Script;

Now create a chart with dim from dimensiontable; sum(measure) and check Include Zero Values

Do not use key fields used to associate tables as dimensions in your chart

both tables have Include zero values checked, but as you can see dim sourced from a separate dimensiontable will show 0 when there is no associated data

Output

Re: show all the columns in a table.

vinieme12 — Thu, 28 Apr 2022 17:02:59 GMT

@rushi1093 kindly close the thread by marking a response as solution if your problem is resolved