Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

tizianacaem
New Contributor

Set Analisys question

Hi all,

I'm having some problems with a set analisys expression, someone can help me solve it? The expression is this one:

count

(distinct {$<Anno_iscrizione = {$(#=Only(FatAnno)-1)}, Mese_iscrizione= {$(#=Only(FatMese))}>} CLIENTE)



I don't know if its possible to use Count disctinct in set analisys and if my synthass is correct

I would really appreciate some clarifications or indications..

thanks

Tiziana

Tags (1)
8 Replies
MVP
MVP

Set Analisys question

Hello Tiziana,

Everything seems to be allright, except for

Count({set} DISTINCT CLIENTE)
using DISTINCT keyword after the set. Hope this helps.

tizianacaem
New Contributor

Set Analisys question

thank you for your help!

Actually in this way works, but only if i delete the secon condition (the one of mounth)

some other idea?

MVP
MVP

Set Analisys question

How do you store FatMese field (which format) in your data source? If you try for example to get with set analysis those who

{< FatMese = {3} >}
does the chart work?

tizianacaem
New Contributor

Set Analisys question

FatMese is like gen, feb, mar etc. if i use 3 is doesn't work, instead it work correct if i use mar.

tizianacaem
New Contributor

Set Analisys question

I take advantage of your availability to ask one more question:

if i want to show the percentuage of single month respect the full year, is correct (but i think no as it doesn't work) this syntax:

sum

( {$<FatAnno = {$(#=Only(FatAnno)-1)}>} System_Net_Amount)/sum( {1<FatAnno = {$(#=Only(FatAnno)-1)}>} total System_Net_Amount )





MVP
MVP

Set Analisys question

Depending on how are your dimensions built (I'd recommend to add "Month" as dimension, actually), something like the following should work to get month results of total year results

sum({$< FatAnno = {$(#=Only(FatAnno)-1)} >} System_Net_Amount) / sum({1< FatAnno = {$(#=Only(FatAnno)-1)} >} System_Net_Amount)


Hope this helps

tizianacaem
New Contributor

Set Analisys question

Bad news.. in this way the result is 100% in every row, rather than the percentage for the year that i'm considering..

For the current year (Max (TOTAL Year) ) i usually use

Sum (System_Net_Amount)/Sum (Total System_Net_Amount)

but i'm not able to translate this condition with setAnalisys for (Max (TOTAL Year) )-1

The month is already a dimension.

i don't know what to do.. any other ideas??

Thank you very much

tizianacaem
New Contributor

Set Analisys question

thank you for your help.. i find the solution writing total before the SysteNetAmount..

now is working correctly!!!

Community Browser