topic Re: Different data depending on filter in QlikView

Different data depending on filter

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

hello,

i have the following data: and i would like depending what i choose on the filter to show different data:

for example:

on segment i should have only segment 1,2 and 3, but i choose the first and second segment the result it has to be 34.

¿can you help me?

Segment	sum(Clients)
1-2	34
1-3	543
2-3	434
1-2-3	342
1	54
2	43
3	654

Re: Different data depending on filter

Chanty4u — Mon, 31 Jul 2017 12:48:44 GMT

hi you can create flags in script like below

aa:

load * Inline [

Segment ,sum(Clients)

1-2 ,34

1-3 ,543

2-3 ,434

1-2-3, 342

1 ,54

2 ,43

3 ,654

];

result:

LOAD * ,

if(Segment='1-2',0) as flag1,

if(Segment,'1-3',1) as flag2,

if(Segment,'1-2-3',2) as flag3

.........like all

Resident aa;

Re: Different data depending on filter

ahaahaaha — Mon, 31 Jul 2017 14:09:30 GMT

Hi,

May be like as at attached file?

Regards,

Andrey

Re: Different data depending on filter

MarcoWedel — Mon, 31 Jul 2017 23:55:57 GMT

Hi,

maybe you could use an AND-mode List Box on a subsegment field to achieve this result:

table1:
LOAD Text(Segment) as Segment,
    Clients
inline
[Segment,Clients
1,54
2,43
3,654
1-2,34
1-3,543
2-3,434
1-2-3,342];

tabSegments:
LOAD Distinct
    Segment,
    SubField(Segment,'-') as Seg
Resident table1;

hope this helps

regards

Marco

Re: Different data depending on filter

pathiqvd — Tue, 01 Aug 2017 04:36:24 GMT

Hi,

Try like this,

step1:-

load Distinct *,SubField(Segment,'-') as Segment1 inline [

Segment,Clients

1-2,34

1-2,30

1-3,543

2-3,434

1-2-3,342

1,54

2,43

3,654

];

step2:-

Create one variable like vSeg=if(GetSelectedCount(Segment1)>1,Concat(distinct Segment1,'-'),Segment1)

Segmen1 field take as filter and write exp like,

=sum({<Segment={"$(vSeg)"}>}distinct Clients)

Regards,

Re: Different data depending on filter

MarcoWedel — Tue, 01 Aug 2017 23:30:48 GMT

maybe also possible:

regards

Marco