topic Re: Summary Table in Qlik Learning Discussions

Summary Table

Wed, 12 Nov 2014 14:16:38 GMT

I have created two straight tables which show the results of two if statements. One has 3 results and the other has 2. I would like to create a separate summary table which has the check, so check 1 & 2, along with the number of results. Illustration below.

And is it possible to drill down from this, so get further information on the person with that name

Check 1

Name	Header 2
Tom	1
Paul	1
Bill	1

Check 2

Name	Header 2
Jill	1
Adele	1

Summary

Check Number	Header 2
Check 1	3
Check 2	2

Thanks for any help anyone can give

Iain

Re: Summary Table

MK_QSL — Wed, 12 Nov 2014 14:24:38 GMT

Check1:

Load *,'Check 1' as [Check Number] Inline

[

Name, Header 2

Tom, 1

Paul, 1

Bill, 1

];

Check2:

Load *,'Check 2' as [Check Number] Inline

[

Name, Header 2

Jill, 1

Adele, 1

];

Now create a Straight Table

Dimension

[Check Number]

Name

For 2nd Dimension, Tick Enable Conditional and write below in expression

IF(GetFieldSelections([Check Number])>0,1,0)

Expression
COUNT([Header 2])

Re: Summary Table

Gysbert_Wassenaar — Wed, 12 Nov 2014 14:27:09 GMT

Perhaps a straight table without dimensions and the two expressions from your other straight tables. Disable the total mode for the expressions and enable the Horizontal option on the Presentation tab.

Re: Summary Table

Wed, 12 Nov 2014 14:44:48 GMT

Thanks for that, it worked. However the information I used was an example and I could have thousands of pieces of information that changes daily, is there a shortcut instead of typing that load in?

Thanks,

Iain

Re: Summary Table

Anonymous — Sat, 13 Dec 2014 23:12:21 GMT

Hi Gysbert,

is there a way to create a straight table without dimensions? I have one with two expressions only and I think it needs at least one dimension.

Re: Summary Table

Agis-Kalogiannis — Sun, 14 Dec 2014 10:47:30 GMT

You can create a dimensionless Straight table Piotr, and add only expressions to it.