Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
trishita
Contributor III

Currently I am having redundant data for my script

Redundant.JPG

Redundant.JPG

 

 

 

For some reason I am having duplicate data for the same PensionCase Name which should vary with the manager name

My code looks like this:

If(Match([Pensionseinrichtung], 'HPF PPD'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF PPD'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPF PPA'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF PPA'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPF EK'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPF EK'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPK'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPK'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ALL'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ALL'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR SMST'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR SMST'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert]),
If(Match([Pensionseinrichtung], 'HPR ZF'),
Sum(TOTAL {$<Pensionseinrichtung = {'HPR ZF'}, Stichtag_HPV = {'31.12.2018'}>} [HPV Buchwert])
, 'Unknown')))))

1 Solution

Accepted Solutions
trishita
Contributor III

Re: Currently I am having redundant data for my script

The problem was solved with a new logic.Thanks all

2 Replies
agni_gold
Valued Contributor II

Re: Currently I am having redundant data for my script

This is happening just because of your currency column in table , one is in USD and other is in EUR ,
if you looking for some other output so
can you send you sample app and required output.
trishita
Contributor III

Re: Currently I am having redundant data for my script

The problem was solved with a new logic.Thanks all