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

Announcements
Join us in Bucharest on Sept 18th 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