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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Flip the number values with images in pivot table

Hi all,

Could you please anybody help me to flip values in

Pivot table with number/images based on list box value.

I.e.if I select number item from list box values should show as numbers in pivot table else if I select image option the values in pivot table should display with

Right mark/Cross mark/exlimenater mark.

3 Replies
mdmukramali
Specialist III
Specialist III

Hi,

Can you attach the sample Qvw file?

I want to see what values/images you have in List box?

Thanks,

Mukram.

Anil_Babu_Samineni

In Qlikview, we have default icons like Images which covers Icons / Arrows / Smileys etc. So, you can get it those as per needs. But, Question not clear what you did and needed

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Please  find data below

Pivot dimensions are class->student name->subject name.

Assume 3 subjects in each class and subject column will hold marks secured in that subject, pass>36 ,fail <36 Or student absent(exlimenate symbol)

If X class student attended any subject exam if passed

>36 than show right check symbol/secured marks  ,if fail<36 than show X symbol/secured marks ,if not attended show null value/exlimenation markin each subject column

Hence need a flexibility to view data in table either with numbers of each subject or the images associated to each subject by using another list box buttons {numbers,symbol}

If select numbers button  data show in table with numbers or if select symbol the data should in pictorial representatinon

.I. E. Right mark/Cross mark/exlimenation mark