Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
DGAL1
Contributor III
Contributor III

set analysis

i have products sold , and i want their count using % contribution with the ID column

Labels (1)
1 Solution

Accepted Solutions
RamanaKumarChintalapati
Partner - Creator
Partner - Creator

Hi @DGAL1 ,

 

Is this is your Requirement,

RamanaKumarChintalapati_0-1706873333435.png

by using @LRuCelver  mentioned formula

 

Thanks!!!!

View solution in original post

6 Replies
LRuCelver
Partner - Creator III
Partner - Creator III

I'm not quite sure I understand your question correctly. Maybe you could provide a bit more information on what data you have and what you want to calculate with it.

To determine the percentage share of a selected value in e.g. a table you can use something like:

Count(ID) / Count(total ID)

 The keyword "total" makes it so all values in the current selection will be counted, regardless of the content of e.g. a row in a table.

RamanaKumarChintalapati
Partner - Creator
Partner - Creator

Hi @DGAL1 ,

 

Is this is your Requirement,

RamanaKumarChintalapati_0-1706873333435.png

by using @LRuCelver  mentioned formula

 

Thanks!!!!

DGAL1
Contributor III
Contributor III
Author

=Dual(WeekDay(Date-1), Mod(WeekDay(Date) - 2 + 7, 7) + 1)

kindly help me on the correct code , the above graph when i select the values for saturday are on sunday 

Momo111_0-1706876540838.png

 

mnk
Partner - Contributor
Partner - Contributor

Try below expression.

=Dual(WeekDay([Date]-2), Mod(WeekDay([Date]) - 2 + 7, 7)+1 )

Let me know whether it works. If not, explain more on your requirement.

DGAL1
Contributor III
Contributor III
Author

the above has failed , but when i write weekday(Date) i get the correct results however sunday starts on the graph

jochem_zw
Partner Ambassador
Partner Ambassador

Count(ID)/Count(Total ID)

format as a %