topic Re: Pivot table Expression merge in QlikView

Pivot table Expression merge

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have raw data like below. Want to merge sum(sales ) expression in pivot table.

Thanks

Gireesh

YoussefBelloum — Thu, 19 Apr 2018 07:46:35 GMT

Hi,

try this:

=sum(total <APP> SALES)

this expression will give the exptected output, but it is not possible to merge cells on qlik

shiveshsingh — Thu, 19 Apr 2018 08:17:36 GMT

May be this

gireesh1216 — Thu, 19 Apr 2018 08:58:20 GMT

Not working

gireesh1216 — Thu, 19 Apr 2018 09:00:37 GMT

Thanks Singh,

Hear results coming in 2 times.I am looking only one time results like above.

YoussefBelloum — Thu, 19 Apr 2018 09:00:50 GMT

What is not working ?

can you attach screen shot of what you have so far ?

sasiparupudi1 — Thu, 19 Apr 2018 11:54:12 GMT

May be try

gireesh1216 — Thu, 19 Apr 2018 13:30:43 GMT

But I am looking exact output like this.

sasiparupudi1 — Thu, 19 Apr 2018 17:09:47 GMT

how about this

Paknanarn23 — Tue, 02 Jul 2024 04:17:04 GMT

Hi, Sasiparupudi

How do you do this? please tell me