Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II
‎2017-09-22 04:03 AM

Pivot Table expression/Dimension

Hi,

I would like to know how I can present in a PivotTable three expression for each expression a single dimension.

thank you for you

C-Attached Screenshots

Preview file
77 KB
1,004 Views
0 Likes
6 Replies
balar025
Creator III
Creator III
‎2017-09-22 04:16 AM

What are your dimensions and expressions?

You can use pivoting by dragging dimensions horizontally.

854 Views
0 Likes
MauriceLudo
Creator II
Creator II
‎2017-09-22 05:19 AM
Author

In response to balar025

Thank you for your reply

'Dimension : Num_Week_Cloture'

'expression traitement with Num_Week_Cloture'

'count( {<[File d’attente]={'N1-Developpement'}, Statut={'Annulée','Terminé'}>} N°Ligne_Nb)'

'Dimension : Num_Week_Création'

'expression Flux with Num_Week_Création'

'count( {<[File d’attente]={'N1-Developpement'}>} N°Ligne_Nb)'

look Attached App

Verif1.qvw
854 Views
0 Likes
balar025
Creator III
Creator III
‎2017-09-26 02:12 AM

In response to MauriceLudo

Still it is not clear.

In your example, i can see there is serial key dimension with there different expression and calculation is different for each serial key(Creation/Cloture) and expression except Stock.

What is your final output you needed?

Regards,

Ravi Balar

854 Views
0 Likes
balar025
Creator III
Creator III
‎2017-09-26 02:14 AM

In response to balar025

Is it your expected output?

Num_Semaine 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
FluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStockFluxTraitementStock
00760076007600760076107617476121476292176241476245763016763022762113762118761017762518761622761638761927761113762526762629762647762020762427762828762116761397613217619237614876887620187620227617217681976007600760076007600760076007600760076007600760076007600760076
854 Views
0 Likes
MauriceLudo
Creator II
Creator II
‎2017-09-26 04:16 AM
Author

In response to balar025

Thnak you Balar,

yes exactly for processing and flow, on the contrary stock it is false, the rule to calculate stock it is, also presentation like the scrennshort top

854 Views
0 Likes
MauriceLudo
Creator II
Creator II
‎2017-09-26 05:40 AM
Author

In response to balar025

Stock :   S1 = F-T

                 S2 = stock S1 + F-T

                 S3 = Stock S2 + F-T

854 Views
0 Likes