topic Re: group in QlikView

group

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

hi ,

I have field like region, in that I have south ,north,east,west In each region I have some other states

so I have a pie with the region and count(id) so I need to show only South and North count only how to do that?

region is coming from 3tables used applymap to get the region.

how to group only north and south?

its_anandrjs — Thu, 28 Sep 2017 05:02:30 GMT

Share sample or do like this

count( {<Region = {'north','south'} >} id)

Note :- In dimension select Suppress when value is null

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:04:36 GMT

Can this do?

count({<region = {"South","North"}>} id)

avinashelite — Thu, 28 Sep 2017 05:43:50 GMT

Other way would be

in the dimension

if(Region='north' or Region='south',Region)

suppress null in the dimension

expression

Count(id)