topic Re: show feild in pivot in QlikView

show feild in pivot

Anonymous — Sun, 23 Nov 2014 05:36:13 GMT

hi,

how can i show expresion in some condiotion with set analysis in pivot for exm.

i want to show date feild for only when feild="tostr" and code="3".

how can i use set analysis with no : sum,avg... ?

thanks'

yarin.

its_anandrjs — Sun, 23 Nov 2014 05:44:58 GMT

Hi,

Try like

Sum({<feild = 'tostr', code = '3'>} Metrics)

Regards

Anand

Anonymous — Sun, 23 Nov 2014 05:58:38 GMT

my Metrics is date , when i write smu the date is change.

do you have any idea ?

mybe there is another function not sum ?

thanks'

yarin.

ashfaq_haseeb — Sun, 23 Nov 2014 06:07:03 GMT

Try something like this

max({<feild = 'tostr', code = '3'>} Date)

only({<feild = 'tostr', code = '3'>} Date)

Regards

ASHFAQ

its_anandrjs — Sun, 23 Nov 2014 06:13:48 GMT

Hi,

Then try like

Only ( {<feild = 'tostr', code = '3'>} Date )

In the calculated dimension for Date like

If( feild = 'tostr' And code = '3', Date)

//And select Suppress When value is NULL

Regards

Anand