Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

show feild in pivot

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.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Try something like this

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

or

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

Regards

ASHFAQ

View solution in original post

4 Replies
its_anandrjs
Champion III
Champion III

Hi,

Try like

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

Regards

Anand

Anonymous
Not applicable
Author

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
Champion III
Champion III

Try something like this

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

or

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

Regards

ASHFAQ

its_anandrjs
Champion III
Champion III

Hi,

Then try like

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

Or

In the calculated dimension for Date like

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

//And select Suppress When value is NULL

Regards

Anand