topic Re: For Straight Table expression total query in QlikView

For Straight Table expression total query

mayankraoka — Sat, 22 Jul 2017 15:39:05 GMT

Hi All,

Is there any way we can conditionally show Total value in straight table?For example,I have 2 dimensions and 3 expressions in straight table.I have enabled Expression total option for all 3 expressions.Now I have 1 condition and if that condition is true then only we want to show total value else will show NA.

Any one have any idea how to achieve this in Straight table?

Regards,

Mayank

Re: For Straight Table expression total query

passionate — Sat, 22 Jul 2017 16:10:52 GMT

Hi Mayank,

For pivot table you could use Dimensionality()=0 for Total

there is a workaround in straight table

Use two Objects and hide show the two straight table based on your condition

Regards,

Pankaj

Re: For Straight Table expression total query

antoniotiman — Sat, 22 Jul 2017 16:21:21 GMT

HI Mayank,

assuming

Condition A > B end Expression Sum(Value)

If(A > B,
If(Dimensionality() > 0,Sum(Value),'NA'),Sum(Value))

Regards,

Antonio

Re: For Straight Table expression total query

effinty2112 — Sat, 22 Jul 2017 21:55:15 GMT

Hi Mayank,

Your best approach would be to have duplicate columns in your straight table. Each pair would have one showing the total and one that does not. Use your condition to show or hide the correct column.

cheers

Andrew

Re: For Straight Table expression total query

mayankraoka — Sun, 23 Jul 2017 08:19:12 GMT

Thanks Antonio,

I have different condition for total and other values.

Regards,

Mayank

Re: For Straight Table expression total query

antoniotiman — Sun, 23 Jul 2017 08:29:27 GMT

Use it for each column accordin Your Conditions and Expressions

Column 1

If(A > B,.........,Sum(Value))

Column 2

If( C < A,........., Count(Distinct Field))

Regards,

Antonio

Re: For Straight Table expression total query

mayankraoka — Sun, 23 Jul 2017 08:36:06 GMT

Thanks,It is working .

Regards,

Mayank

Re: For Straight Table expression total query

mayankraoka — Sun, 23 Jul 2017 10:16:44 GMT

Hi Antonio,

One more query:

I have checked with Pivot table for dimentionality()=0 it is working fine as expected.Will Dimenstionality()>0 will work in straight table?

Regards,

Mayank

Re: For Straight Table expression total query

antoniotiman — Sun, 23 Jul 2017 11:17:08 GMT

Yes also in Straight Table.

Regards,

Antonio

Re: For Straight Table expression total query

mayankraoka — Sun, 23 Jul 2017 11:33:27 GMT

What I know is dimensionality()=0 Wont work in straight table.So what integer value it takes for expression total?

I am trying to understand is dimensionality()>0 is not for total?

Regards,

Mayank

Re: For Straight Table expression total query

antoniotiman — Sun, 23 Jul 2017 11:47:40 GMT

See Attachment.

Re: For Straight Table expression total query

mayankraoka — Sun, 23 Jul 2017 15:45:30 GMT

Thanks Antonio .Appreciate your help ...