topic Re: Set Analysis in QlikView

Set Analysis

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

Hi,

I want to use a part of set analysis to be stored in variable. Any suggestions?

I have data like,

Description Amt

A 100

B 200

C 300

D 400

Set analysis is like =sum({<Description = {'A'}> }Amt). But I want to store Description = {'A'} in a variable and use that in a expression.

Digvijay_Singh — Tue, 24 Apr 2018 02:39:00 GMT

May be like this -

Anonymous — Tue, 24 Apr 2018 02:42:13 GMT

Thanks its working.

May I know why we get red line?

Digvijay_Singh — Tue, 24 Apr 2018 02:46:06 GMT

You may ignore that, its showing because editor assumes set expression is not properly written.

vishalarote — Tue, 24 Apr 2018 05:57:09 GMT

May be Try this Manner

make Variable vDescA

Description='A'

n write Set Analysis like

sum({<Description={"=$(vDescA)"}>}Amt)

Anonymous — Tue, 24 Apr 2018 06:38:29 GMT

if I want to add A Or B or C, then expression isn't working

vishalarote — Tue, 24 Apr 2018 06:52:00 GMT

then u used in vDesc

wildmatch(Description,'A','B','C')

and Write expression in text object

sum({<Description={"=$(vDesc)"}>}Amt)